Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
5 hours ago

Refresh Failed

I recently connected an Excel file to one of my PowerBI reports and now the automatic overnight refreshes have stopped working. I had previously done the same thing with a different report and it ...
Need Help
power bi
Show and Tell
rampie's avatar
rampie
Icon for Kudo Commander rankKudo Commander
38 minutes ago

Try this: open the workbook in OneDrive from the browser, go to ... > Details and copy the Path. Then in Power BI Desktop use Get data > Web, paste that link and sign in with Organizational account. Point your query to that new source (or in Advanced Editor swap the File.Contents("C:\...") part for Web.Contents("<the link you copied>")), republish, and in the Service set the data source credentials to OAuth2.

 

Steps are here: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

 

Hope this helps!

https://www.linkedin.com/in/richard-ampie-218a07247/