Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |