Forum Discussion
Advocate IUnable to change path for datasource in uploaded pbix file in powerbi.com
Advocate IThanks for the suggestion, unfortunately it made no difference. I had deleted and uploaded the dataset many times before but I hadn't deleted the data source from powerbi desktop before uploading it. I did that now as you suggested but it made no difference.
I wonder where these are stored as they are not anywhere in the pbix file that can be edited at least...
Community ChampionHmmm, I'm going to have to spin up an experiment on that one, that's really weird if they are gone from data sets, gone from PBIX file and you upload the new PBIX file and they reappear. Very odd.
- mliljenberg
After much frustration, I managed to get it to work. What I needed to was to completely uninstall Desktop gateway as done before, but in conjunction with completely uninstall Power BI desktop and then open the pbix file fresh again, now it rebuilt all connections and after saving and uploading it to powerbi.com no it didn't try to connect to "ghost" data sources wheren't there anymore.
Refresh unfortunately fails though both manually and scheduled although they work on the desktop, but that is another story and one that I will raise in a different thread. Thank you so much for helping out Smoupre!
- Greg_Deckler
Happy to help, I've had success with local Excel files but not Excel files on network drives...