Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, today I had an issue with using the power BI service as my datasource
I have 1 dataset in the workspace and 2 reports that connect to this dataset via PowerBI service
I removed the dataset and the 2 reports and went to upload new versions of all of them, now the dataset has uploaded fine however the 2 reports that connect to the dataset are saying they cannot find the datasource to connect to (because I deleted and re uploaded one and the files are looking for the old datasource)
However the report files are stuck in an infinate loop of trying to connect to the old PowerBI service that doesent exist anymore and i cant use any menu functionality of the report to repoint to the new datamodel
Any ideas on how to get past this error loop?
Thanks!
Solved! Go to Solution.
Ok after messing around i found a pretty sketchy solution:
Create a blank power BI file and connected it to the new PowerBI data service
save this file and rename it to .ZIP and extract it - there will be a file called connections
Made a copy of all the report PBIX file and rename them to .ZIP
extract all these files and replace the 'connections' file with the connections file of the blank PBIX file created above.
Rebuild the extracted files back into a .ZIP and rename back to .PBIX
- When i tried opening this it said the files have become modified or corrupt and it would not open.
After some googling I found if I sent it off to another PC you would be able to open it - this worked.
So on the other PC i opened the PBIX report files and exported them all to PBIT then sent the back to the original PC
Now i can open them and they are connected to the new PowerBI service
Still have no idea why the files got stuck in an infinte error message loop when trying to connect to a datasource that doesent exist.
Ok after messing around i found a pretty sketchy solution:
Create a blank power BI file and connected it to the new PowerBI data service
save this file and rename it to .ZIP and extract it - there will be a file called connections
Made a copy of all the report PBIX file and rename them to .ZIP
extract all these files and replace the 'connections' file with the connections file of the blank PBIX file created above.
Rebuild the extracted files back into a .ZIP and rename back to .PBIX
- When i tried opening this it said the files have become modified or corrupt and it would not open.
After some googling I found if I sent it off to another PC you would be able to open it - this worked.
So on the other PC i opened the PBIX report files and exported them all to PBIT then sent the back to the original PC
Now i can open them and they are connected to the new PowerBI service
Still have no idea why the files got stuck in an infinte error message loop when trying to connect to a datasource that doesent exist.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.