Forum Discussion

Gonqq's avatar
Gonqq
Helper I
5 years ago
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 ...
Need Help
  • Gonqq's avatar
    Gonqq
    5 years ago

    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 

Gonqq's avatar
Gonqq
Helper I
5 years ago

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