How to change datasets without changing the URL

[Anonymous]

Hi,

Is there any way to change Datasets on PowerBIServiece without changing the report URL?

We are publishing the PBI report to our customers.
The data source for the report is SQLServer.

What we want to do is the following:
1. Add a new table to DataBase (or edit it with PowerQueryEditor (Advanecd Editor))
2. Update the report with the added or updated data.
3. Publish the updated report without changing the URL of the report we are publishing to our customers.

In my image, "1." can be realized by replacing the Datasets, and "2." can be implemented on PBIService.

[Other]
・OnPremiseGateway is used.
・I am using OnPremiseGateway, and the data acquisition method is Import, not DirectQuery.

If anyone knows how to do this, I would appreciate it if you could let me know.

Thank you.

[selimovd · Accepted solution]

Hey @Anonymous ,

you can modify your PBIX file and re-publish it to the same workspace. 

You will get the question if the dataset/report should be overwritten. You can confirm that. The URL will stay the same.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thank you for your answer.

I didn't think it would be possible to just overwrite the file, since I had to rename the file and upload it every time.
I was able to perform the desired action.

Thank you again.