How to create an Excel table from a DAX (Power BI) query to be used for Data Validation
I had a requirement where the customer wanted to make sure that the right user could only see the colour from the stock item assigned to them. Essentially using the Excel file for Row Level Security. For the Row level security to work correctly it required the colour name to be an exact match. For me to ensure that this...
The post How to create an Excel table from a DAX (Power BI) query to be used for Data Validation appeared first on FourMoo | Power BI | Data Analytics.
Published on:
Learn moreRelated posts
Deprecation of Power BI Integration within SharePoint Lists and Libraries
Today, we are announcing the retirement of the Power BI integration within SharePoint lists and libraries. This change impacts customers who c...
AI and Agentic Development for Power BI
New Fabric Tenant Setting: “Set alert” Button Visibility for Power BI Users
A new Microsoft Fabric tenant setting will make the “Set alert” button visible to all Power BI web users, enabling them to create Fabric Activ...
What Happens When Power BI Direct Lake Semantic Models Hit Guardrails?
Direct Lake mode in Power BI allows you to build semantic models on very large volumes of data, but because it is still an in-memory database ...
Power BI Beginner's Tutorial (2025)
Faster DAX in Power BI
Performance Testing Power BI Direct Lake Models Revisited: Ensuring Worst-Case Performance
Two years ago I wrote a detailed post on how to do performance testing for Direct Lake semantic models. In that post I talked about how import...