Power BI Desktop import data from excel stored in onedrive business

[konstantinos]

Hi,

Does anyone tried it? There must be a way (except sync with local library) since most services are under O365 umbrella..

Any ideas?

I tried from "Web" sources with onedrive http path but my user cannot be authorised.

API maybe?

[andre]

I tried From Web option and then used Organization Account as authentication option and it worked.  Now, the tricky part was to pass the correct URL.  I had to delete some stuff after "?" in the link to get it to work.

[jjmauras]

I'm having trouble with this as well. What did you delete after the "?" to get it to work. Thanks.

Edit: I found a solution. The path has to be altered in a specific way. This helped:

https://medium.com/@Konstantinos_Ioannou/onedrive-powerbi-desktop-use-valid-paths-to-import-data-sto...

[curth · Accepted solution]

If you say "From Web" with an appropriate URL and authentication method, it should work. For me, entering the URL https://microsoft.sharepoint.com/teams/montego/Documents/Versions.xlsx and specifying "Organizational account" gvies me the Excel file.

[konstantinos]

Thanks, is working great..& schedule update from PowerBI..

Only a strange behaviour (bug) when refreshing on PowerBI service.When I "Refresh Now" and the tiles automatically update values when I drill down (click tile) the report had the old data..need to Refresh the brower..