Forum Discussion

mliljenberg's avatar
mliljenberg
Icon for Advocate I rankAdvocate I
11 years ago

Unable to change path for datasource in uploaded pbix file in powerbi.com

I have a pbix file with connections to two different Excelfiles. In powerBi desktop, it works and I have change the source pointing to the correct location on the desktop. The files were previosly st...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi folks,

 

Today I ran into the very same problem. I have a data source to a file in SharePoint Online. The file was moved to a different location in SharePoint. I updated the path in Power BI Desktop accordingly, then published the PBIX file to the Power BI Service.

Now the data refresh in the Power BI Service doesn't work anymore, because the data source is duplicated: both the previous version and the new version show up. And the old one obviously doesn't work anymore.

 

This makes the refresh impossible. There is an extra - and broken - data source in the web, which doesn't exist on the desktop app. I deleted the data set, then re-published it: that didn't change anything. There is a ghost datasource, which is visible only in the web service.

 

I saw in this thread that this was supposed to be fixed a year ago. Well, it isn't. Or it came back. Anyways, it needs fixing. I can reproduce the issue.

Arnaud91's avatar
Arnaud91
New Member
7 years ago

When I upload and configure this report https://gallery.technet.microsoft.com/PowerON-Power-BI-ConfigMgr-0cd61c5f to our on premise power bi (January 2019) I have a very strange issue, it shows me 2 datasource on the Data sources tab in the report server web page but i see only one in power bi desktop...

 

The first one is

pdms01ps1;CM_P01

 Probably a test when the power PI report was generated and as it is non existent in my environement i cannot schedule a refresh of the report...

 

Any idea ?

 

Arnaud