Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I created a report using Power BI Desktop and used a local excel workbook as the data source. I have published it to PowerBi.com, 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?
Hi @Anonymous ,
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..