Uploaded April 2026 | Updated September 2026, 2 weeks ago
👩🏻🎓Do you want to learn Power BI or Professional Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
⏬Download PBIX containing Power Query code
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgBeHQsuiV8NRY7fzpzCYkQNAWWR2KHq0fiPPorBt_hFpAM?e=A7lM3g
This video explores an interesting alternative to traditional dataflows in Microsoft Power BI—especially as Dataflow Gen1 edges closer to deprecation. Also, Dataflow Gen1 doesn’t support row-level security (RLS), which can be problematic for some scenarios. In this walkthrough, you’ll discover a powerful workaround that leverages core Power BI functionality to not only replicate dataflow behavior but also fully respect RLS, giving users access only to the data they’re permitted to see.
The solution uses a technique involving Analysis Services queries within Power Query to extract individual tables directly from a semantic model—even within Pro workspaces. With step-by-step guidance, you’ll learn how to connect to datasets, dynamically surface available tables, and enable end users to build their own reports securely. This approach opens up flexible, refreshable import scenarios while maintaining strict data governance. If you’re looking for a smarter, more secure way to manage data access in Power BI, this is definitely worth exploring.
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
👩🏻🎓Do you want to learn Power BI or Professional Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
⏬Download PBIX containing Power Query code
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgBeHQsuiV8NRY7fzpzCYkQNAWWR2KHq0fiPPorBt_hFpAM?e=A7lM3g
This video explores an interesting alternative to traditional dataflows in Microsoft Power BI—especially as Dataflow Gen1 edges closer to deprecation. Also, Dataflow Gen1 doesn’t support row-level security (RLS), which can be problematic for some scenarios. In this walkthrough, you’ll discover a powerful workaround that leverages core Power BI functionality to not only replicate dataflow behavior but also fully respect RLS, giving users access only to the data they’re permitted to see.
The solution uses a technique involving Analysis Services queries within Power Query to extract individual tables directly from a semantic model—even within Pro workspaces. With step-by-step guidance, you’ll learn how to connect to datasets, dynamically surface available tables, and enable end users to build their own reports securely. This approach opens up flexible, refreshable import scenarios while maintaining strict data governance. If you’re looking for a smarter, more secure way to manage data access in Power BI, this is definitely worth exploring.
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
