Forum Discussion
Swap semantic model in Power BI Service
Hi, I created a report directly in the service based on a semantic model in another workspace, and now I'd like to change the source to a semantic model in the same workspace as the report. However, I cannot find a way of doing this...
Of course it would also be theoretically possible to solve the issue by being able to download the report as a .pbix file, if they were in the same workspace, but I cannot due to the limitations.
I saved a copy of the report to the original workspace where the original semantic model was in the hope that I could download it from there, but this was also not successful:
Is there something obvious I've missed?
There are any option that I can think of is to use git integration and get. the PBIX file into source control and doing it that way you would get the data set and the report. What you could then do is get the pbip file and open that in Power BI desktop which will allow you to then get the report.
15 Replies
To edit, follow these steps:
- In Power BI Service, open the report and select the Edit mode.
- From the File menu, select Download this file.
- Choose the option to create a copy of your file with a live data connection.
- Open the file in Power BI Desktop.
- Modify the data source from the Data source settings menu.
works like a charm!
Como? quiero modificar el model semántico no la fuente de datos
You're missing the point.
In the Desktop you can do that. But the point is that we made a report online (in the Service) that is not downloadable because of a scrazy limitation (report was build on a dataset in another workspace).
So if not downloadable -> no pbix file, if no pbix file -> no Desktop functionality.Try google rebind reports. Thats your solution using rest api calls
Was not the goal of this post, but this did help me on my end. Thanks a bunch !!!
There are any option that I can think of is to use git integration and get. the PBIX file into source control and doing it that way you would get the data set and the report. What you could then do is get the pbip file and open that in Power BI desktop which will allow you to then get the report.
You can rebind the report to the new Semantic Model using the following link (will be done by REST API). Reports - Rebind Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
The only workaround is to download the reports and then open it up in Power BI desktop and connect it to the new source.
Thanks GilbertQ , I edited my question to make it a bit clearer. The original report was based on a semantic model in another workspace. When I created it I (obviously) did not realise this was a limitation.
Hi, how can i change the semantic model in the Power BI Desktop? I have tried "Transform data" and "Data source settings", but in the Data source i don't see a semantic model, but instead it gives me the connection to the Azure Data Explorer. thanks!
This is indeed crazy.
So you want, in a corporate environment, one semantic model in workspace hidden for end users, and have them access it via the Onelake data hub.
And then explain them to never use the service to create reports because of this limitation.
????I had this same problem.
Assuming your semantic models have near identical structures with all measures the same etc.
good old select all, copy & paste between the downloaded version and the new version connecting to the semantic model I needed to use.
Another avenue that may work for you if it's identical schemas is downloading both the report from the relevant workspaces, rename of extension from <.pbix> to <.zip> and using notepad++ or some other pure text editor to copy and paste the data from the Connections file into the other and see if you have any joy
Hi rickymcmaster, were you able to fix your problem (swap the semantic model of a report on Power BI Service without downloading / Desktop) by using Git or something else?
I've got this semantic model that somehow got corrupted last week (it won't let me use/create public URLs anymore for any report pointing to it) regardless of its name or content (looks like the DatasetID got "flagged" somehow), and I'd like to edit my 450+ customer reports that point to it and replace the model DatasetID with that of a fresh model, but any Data Source Settings or any manual PBIX/ZIP/Connections file modification that I tried generates reports with the same name but a different ReportID after I publish it with Desktop or upload it on Power BI Service.
I'm interested to know what you found.
Regards, Olivier.
