Forum Discussion
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 it and save it to the many workplaces i have.
I already asked my organization and im not able to use a gateway so im wondering if there's another option.
Thanks in advance.
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
6 Replies
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!
I was able to test it out and it worked quite well for standalone excel files. The problem Im facing now is that when i connect a sharepoint folder (that contais 5 excel files) and make the Navegation step i end up facing this:
This is the shared folder. The content should be "Table" and not "Binary". With this happening i cannot navegate nor combine the files inside that folder and i can't understand why it does this. I watched videos, searched everywhere and can't understand why. When i click and open the Binary on the Content column it gives back a "Data.Format.Error: the URL is invalid" and if i try to combine the content it just doesn't do anything.
Thank you
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
