Forum Discussion
Solved
Refresh PowerBI Report based on Excel local files without gateway
Hi all, As the title suggests, i'd like to know if its possible to refresh a report connected to local data (Excel) on PowerBI service without actually having to enter on PowerBI Desktop, update ...
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
After this path it gives back this error:
"Details: The input URL is invalid. Please provide the URL to the root of a Sharepoint site, or to the service document or entity of its OData Feed (with no query of fragment part)"