Uploaded September 2024 | Updated November 2026, 3 hours ago
How to activate Dynamic Per Person Subscriptions in Power BI
**It requires a Fabric Workspace**
💰Fabric Workspace Required💰
Running the 2 reports consumed 4,000 CUs.
An F2 Pay as you go SKU (120 compute seconds per minute) in Australia costs about AUD$0.01 per minute
so 4,000/120 x AUD 0.01 = 33c
The M Code I show
= Date.EndOfMonth(
Date.AddMonths(
Date.From( DateTimeZone.UtcNow() + #duration(0,8,0,0) ),
-1)
)
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
How to activate Dynamic Per Person Subscriptions in Power BI
**It requires a Fabric Workspace**
💰Fabric Workspace Required💰
Running the 2 reports consumed 4,000 CUs.
An F2 Pay as you go SKU (120 compute seconds per minute) in Australia costs about AUD$0.01 per minute
so 4,000/120 x AUD 0.01 = 33c
The M Code I show
= Date.EndOfMonth(
Date.AddMonths(
Date.From( DateTimeZone.UtcNow() + #duration(0,8,0,0) ),
-1)
)
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link


![ULTIMATE Guide: Combine Files from OneDrive & SharePoint (2025 Update!)
Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🤷🏻♂️365 BUSINESS
Sadly the button is not included in 365 for Business . However you can still use the code in a blank query
= SharePoint.Contents(YOURPATH/, [ApiVersion = 15])
This updated tutorial is your ultimate guide to consolidating multiple Excel files from a OneDrive or SharePoint folder using Excel or Power BI — even when your files contain different sheet names or have empty data. The video walks you through the new OneDrive link changes, explains how to connect with the right URL, and demonstrates how to future-proof your queries by referencing and transforming data dynamically. Youll also learn how to troubleshoot and fix common errors, such as missing sheet names or blank tables, by building a custom error-handling query to identify and isolate problematic files.
🧑🏻🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/
Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/ ULTIMATE Guide: Combine Files from OneDrive & SharePoint (2025 Update!)](https://i.ytimg.com/vi/psQRZQbOFPY/mqdefault.jpg)







