cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anna2109
Regular Visitor

Connect a workbook that changes name to a Power BI dataflow

Hello everyone,

 

I have a spreadsheet that is being located in a specific folder in Sharepoint. The content of the spreadsheet is every year exactly the same, however every year this spreadsheet is being re-created and saved with the same name but with different Financial year at the end. 

What I have to do somehow is to create a dataflow using the spreadsheet but I want the dataflow every year to get the data from the new spreadsheet with the new financial year. 

 

Has anyone tried to do something similar?

 

Many Thanks

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

You could parse the year out of the filename to create a year column, and then use the Table.Max function to keep only the latest record/row (then extract the contents of that to get your updated data).

 

Pat

Microsoft Employee
Syndicate_Admin
Administrator
Administrator

This is easy to do when you use the SharePoint Folder connector (which is generally recommended anyway) rather than any file connector,.

 

Buit - if this only changes once a year then you are probably wasting your time trying to automate this,.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors