How to get an automatic update for a changing link for the data source

[PBIUser1316]

Hello,

I'm getting data from this link: 

https://www.ifo.de/sites/default/files/2019-07/gsk-d-201907.xlsx

where the 07 stands for July.

That link is still working, but in the meantime there is a more recent version online under this link:

https://www.ifo.de/sites/default/files/2019-09/gsk-d-201909.xlsx

The problem is that I don't know when exactly they upload a new table.

Is there a way to make PBI check, if there is a new version and then get data from that table and if not use the recent version?

[v-juanli-msft]

Hi @PBIUser1316 

For the requirement:

PBI check, if there is a new version and then get data from that table and if not use the recent version

We could import lots of file names like gsk-d-201907.xlsx, gsk-d-201909.xlsx

into Power BI, then check if the file names updates.

It is similar to connect to a folder, then check the name of files in this folder.

But when i try to connect to the link  https://www.ifo.de/sites/default/files/

It throws an error.

I have no experience to this site www.ifo.de,

if it is possible to store the data in Onedrive/sharepoint/ local server, this requirement would be achieved.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @PBIUser1316 

I can create a function to let you input the year/month to update the file into Power BI

You could download my file and open Advanced editor to copy my code.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.