Forum Discussion
Refresh PowerBI Report based on Excel local files without gateway
So i managed to make it work. While i was reading some posts i noticed someone said that i was using one drive folder links. Instead i logged directly on SharePoint and copied the link, which turned the code to this:
= SharePoint.Contents("https://XXXXXX.sharepoint.com/teams/O365_PBIControloOramental/", [ApiVersion = 15])
When i tried it on PowerBI i was able to navigate the folders and finally combine the files i wanted.
Thank you for your help _sfrost
If you are using simply an Excel file, you can definitely update the data without using the gateway by following the instructions in below documentation.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Make sure you are not using the local path for the excel file. It should be One Drive path.
Did I answer your questions? Give a thumbs up and accept this post as solution!