Refresh PowerBI Report based on Excel local files without gateway

[Gonqq]

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.

[Gonqq · Accepted solution]

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 

[_sfrost]

@Gonqq 

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!

[Gonqq]

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

[_sfrost]

@Gonqq 

What is the connector you have used here?

If you could paste the M Query, it would be great.

[Gonqq]

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)"

[Gonqq]

Thank you for the quick reply. I will read, test it and put out an answer after. Thank you @_sfrost