Why you should avoid Implicit Measures in your Power BI ...
Everyone who has dabbled around with Power BI knows probably the concept of measures (if not, here’s a […]
Power BI
Aggregate Functions in Power BI including Running Total, Running Average ...
The post Aggregate Functions in Power BI including Running Total, Running Average and Max appeared first on SQLServerCentral.
T-SQL Notebooks: Manage Views Source Control and more
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
Quick Tricks to Make Your Power BI Model Smaller, More ...
Power BI has been a leading data visualization tool in the market for years. It can be […]
How to Slice Data by Fiscal Month using DAX for ...
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on […]
Surveiller l’adoption des Microsoft Fabric Copilots
Cet article est disponible en Anglais sur LinkedIn : Monitoring Microsoft Fabric Copilot Adoption | LinkedIn. Les […]
Génération d’une dimension Date pour les modèles sémantiques en Direct ...
L’un des éléments clés d’un modèle sémantique est la table des dates. Elle fournit une référence pour […]
Contrôler la qualité des modèles sémantiques Power BI au fil ...
Cet article est disponible en Anglais sur LinkedIn : Monitoring the quality of Power BI Semantics Models […]
How to Sort String Date Values on a Power BI ...
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
Identifying Customer Buying Pattern in Power BI – Part 2
In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product […]
Identifying Customer Buying Pattern in Power BI – Part 1
This article is part 1 of a retail analytics market-based analysis in Power BI. In part 1, we […]
Exploration Experience: Saving and Creating Datasets
I have been talking about Data Exploration in Power BI on many of my sessions, specially the […]
Power BI Auto Detect Relationship Failure
In this article, we will talk about how to manually create a relationship by identifying the primary and […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Dynamically Create Tables in Power BI with DAX Functions
The post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral.
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […]
Microsoft Fabric, la solution décisionnelle pour toutes les entreprises – ...
L’événement de l’aMS de Strasbourg a eu lieu le 18 janvier 2024. Cette fois-ci l’événement a eu […]
Feature Flags in Data Projects
My motivation for writing this summary was an interaction with a project owner that didn’t understand why […]
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
New Power BI Explore this Data Feature: An Alternative to ...
The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on […]
Most Overlooked Features in Power BI
The post Most Overlooked Features in Power BI appeared first on SQLServerCentral.
Building Reports with Power BI vs Tableau from SQL Server ...
The post Building Reports with Power BI vs Tableau from SQL Server Data appeared first on SQLServerCentral.
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
Power Query Editor in Power BI for Formatting Text Columns
The post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral.
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Power BI Workspace Permissions and Roles
The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
Meetup du Club Power BI, pilote de la saison 8, ...
Le 11 septembre 2023, le Club Power BI a organisé un nouveau meetup titré « Pilote de la […]
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]
Microsoft Fabric: Using notebooks and table partitioning to convert files ...
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […]
Setting up Drill Through in the New Power BI Report ...
The post Setting up Drill Through in the New Power BI Report User Interface appeared first on SQLServerCentral.
Meetup du Club Power BI de Strasbourg, mai 2023
e 4 mai 2023, le Club Power BI de Strasbourg a organisé un nouveau meetup titré « Power […]
Meetup du Club Power BI de Strasbourg, mars 2023
Le 13 mars 2023, le Club Power BI de Strasbourg a organisé un nouveau meetup titré « Power […]
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
The post DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections appeared first on SQLServerCentral.
Power BI Data Gateway to Connect Data Sources in the ...
The post Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises appeared first on […]
Using Power BI to Analyze My Travels
As a data professional, I have some fun with data in my life. I like numbers, and I […]
Meetup du Club Power BI, Hors-Série spécial Microsoft Fabric
Le 4 juillet 2023, le Club Power BI a organisé un nouveau Meetup titré « Hors-Série spécial Microsoft […]
Supervise the use of Microsoft Fabric
Already one month since the official announcement of Microsoft Fabric and his public Preview: https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/ Since then, […]
Meetup du Club Power BI, La Tournée de Paris
Le 30 juin 2023, le Club Power BI a organisé un nouveau meetup hors série titré « La […]
How to Reduce the Need for Bookmarks Using Parameters in ...
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in […]
Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level ...
The post Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security appeared first on SQLServerCentral.
Multiple Relationships on the same Table in a Power BI ...
The post Multiple Relationships on the same Table in a Power BI Data Model appeared first on SQLServerCentral.
Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s […]