Forum Discussion
One drive refresh not working
I am not sure if this will help but it sounds like our situation has some similarities, here is what I did,
I created a report with a SharePoint Online list as a data source using PBI desktop, then uploaded the .pbix file to one drive.
Then I connect to that file from the PowerBI service, then use the Publish to Web feature to get the report code and embed that code in a SharePoint Online "Script Editor" web part.
Then you can set a scheduled refresh of your data or just do a manual refresh in the Power BI service. In you case you need to upload the .pbix and have the excel data source in your one drive. The refresh of the Power BI report uses the data connection path direct to the source, it does not go to the .pbix
hope this helps
Hi, Anonymous thank you for the answer!
I've followed your steps, but did't have mutch success with the link to Sharepoint Online. I've got the link from the Online published report but it seems to never load once I try to open it.
It does say on the Datasets pannel of the report in Power BI online that the next refresh is due tonight at midnight so that's a step forward. (it still doesn't let me change any settings on scheduled refresh)
However the manual refresh works the same as before. I can refresh Power BI desktop, re-publish to replace the dataset online, then re-issue the online link from the Online app to share with the others. No other refresh works without refreshing the .pbix
I'm not very hopeful the scheduled refresh would work any different at this point.
Thank you very much for the advice!