Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm looking to ensure my Power BI report pulls the latest data from a SharePoint file without having to overwrite the current sharepoint file with the latest data.
Each day a new file is received and saved into the same SharePoint folder with the name (________YYYYMMDDhhmmss).xlsx. This has the exact same layout (columns, tabs, etc) as the previous file, however with the latest data.
Rather than having to copy and paste into the current file, overwrite the current file, or change the load data query each day, I'm hoping there is a way for Power BI to look in the same SharePoint folder and use the latest file.
I am new to Power BI so would greatly appreciate any simple instructions, clearly explained. Thanks community 🙂
Solved! Go to Solution.
Steps would be like this:
Thanks Jeff. And to confirm, would this have the effect that each morning Power BI will pull from the latest/top report in the folder?
Yes, it should. Each refresh will pull the max dated file.
Steps would be like this:
Won't clicking on "Binary" result in a series of steps where the File Name is hard-coded?
Good point. The default generated Power Query will--but you can edit it to use index-based identifiers instead of named ones.
Thank you for your confirmation!
May I also ask how to revise the code to use index-based identifiers in the following auto-generated steps?
= #"Filtered Rows"{[Name="Products.xlsx",#"Folder Path"="https://sharepoint.com/sites/References/"]}[Content]
= Excel.Workbook(#"Products xlsx_https://sharepoint.com/sites/References/")
The row filtering criteria is embedded in the #"Filter Rows" step. You'll need to move this logic into step(s) before #"Filtered Rows", filtering to just one row, and then selecting it.
Something like this:
let
Source = SharePoint.Files("https://sharepoint.com/", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each [Name] = "Filename" and [Folder Path] = "URL"),
Content = #"Filtered Rows"{0}[Content],
#"Imported Excel Workbook" = Excel.Workbook(Content)
in
#"Imported Excel Workbook"
this works! thank you so much!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |