Showing results for 
Search instead for 
Did you mean: 
SilhouetteBS Frequent Visitor
Frequent Visitor

Change Data Source After Publishing to

I created a report using Power BI Desktop and used a local excel workbook as the data source. I have published it to, but now would like to connect it to a copy of the same Excel workbook that is now in OneDrive Business. Is that possible? If so, could someone lead me in the direction to do that?

konstantinos Senior Member
Senior Member

Re: Change Data Source After Publishing to

Hi @SilhouetteBS  ,

 You need to change the query to get data from the onedrive excel and then upload/replace the pbix file in service.

You must change the source from  excel  to from web.


I have written a post on how to write the correct url that is accepted by powerquery.


Also there are some post in the community that also have instruction on how to do it..

Konstantinos Ioannou