Forum Discussion
Post ProdigyHow to Change Live Connection on Report Published in Service and Maintain Same Report URL
v-xiaotang I had to publish it, take the new URL and we had to reprogram our portal using the new URL. I never did figure out how to get this to work as expected.
Super UserHi Shelley ,
I am not sure I am following exactly but let me take a run at it.
If you are changing the data source location for a report that is relatively easy - you open the report, go to the data source settings and change them to the new location. Then, you can publish the report with the same name or old name and all is well.
When you publish a report to a Workspace, it gets a unique URL that you can access it with. If that is what you are referring to, then I think the issue is that you may have changed the report.
If you are opening a report, changing the data source and then publishing to a new location (prod instead of dev) then it will get a new URL in the new workspace. Therefore, you will now have two unique reports - maybe they have the same name, but they have different data sources (dev and prod) and therefore are unique and when published to different workspaces, they will have different URL's.
The report, once published to the workspace will have the same URL even though you continue to re-publish over it (or, if you are using scheduled refresh, then it will still stay the same). The same report publishing over itself doesn't get a new URL each time.
When you rename the report I believe that the URL will change - since the name is new and different and therefore gets a new URL.
If you delete the report on the service, then publish again, that will be a new URL.
Post Prodigycollinq Thank you for response. I too expect it to work as you describe; unfortunately, it does not. I did not change the report at all, other than pointing it to the new PBI dataset, and then I republished the report to the same exact workspace as the original, with the same exact report name. Power BI then created a second instance of the same exact named report in the same workspace, which has to be a different URL as it shows up as two distinct reports, but with the same exact name.
- collinq
Hi Shelley ,
I am wondering if there is a space or something else "invisible" that is different between the two reports. You should not be able to have two reports with the same name in the same workspace. In fact, you should get this error message that you are overwriting something. I created a test PBI file caleld "TestOverwrite". I saved and published it and then I opened it again, made a change and published again to the same spot and received this error message.
If you are sure that the report is exactly the same name then I suggest opening a ticket with Microsoft and let them help sort it out since that sounds like a bug to me. And, please let us know the result so we can all learn!
- Shelley
collinq The report name is exactly the same, I did not change it at all - no extra spaces. A change to the report itself behaves as you state - asks about the overwrite, etc. Did you try changing the Power BI dataset the report is pointing to, and then republishing? I'm really curious as to what your experience is with this specifically.
- collinq
Hi Shelley ,
Good point - I just tested it. I duplicated my original data source. I opened PBI, changed my data source to the new copied version and then published. I went through the two URL's very closely a couple times. No difference at all.
I think you will haveto open a ticket since you either have found something unusual or you have encountered a bug of some sort. Please let us know the result though!