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
Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual
Performance Analyzer is now available in the browser, not just in Power BI Desktop! Actually everyone got excited about this back in September...
Power BI 2025 holiday recap: A decade of innovation and impact
2025 was a monumental year for Microsoft Power BI, marked by its 10-year anniversary and a series of community celebrations, global contests, ...
Power BI Copilot And Report Filters And Slicers
In my last post I talked about how to push Power BI Copilot to get answers from the semantic model rather than the report you’re looking...