Forum Discussion
How to get an automatic update for a changing link for the data source
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?
2 Replies
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
MaggieCommunity 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.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
MaggieCommunity 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.
