cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gonqq
Frequent Visitor

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.

 

Gonqq_0-1618313079828.png

I already asked my organization and im not able to use a gateway so im wondering if there's another option.

Thanks in advance.

1 ACCEPTED SOLUTION
Gonqq
Frequent Visitor

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 

View solution in original post

6 REPLIES 6
Gonqq
Frequent Visitor

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 

View solution in original post

_sfrost
Solution Specialist
Solution Specialist

@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
Frequent Visitor

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:

Gonqq_0-1618328124606.png

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
Solution Specialist
Solution Specialist

@Gonqq 

What is the connector you have used here?

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

Gonqq
Frequent Visitor

Gonqq_0-1618329826671.png

After this path it gives back this error:

Gonqq_1-1618329881429.png

"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
Frequent Visitor

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors