topic Re: Working with live data in Report Server

Working with live data

Nassren — Tue, 31 Jan 2023 18:21:20 GMT

how to replace a live dataset with another live data?

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:33:46 GMT

To replace a live dataset in Power BI with another live dataset, you need to do the following steps:

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:34:02 GMT

1. Go to the Report view: In the Home tab, click on the View Report button.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:34:17 GMT

2. Disconnect the old data source: Go to the Home tab, click on the Get Data button, and then click on the Disconnect icon next to the name of the old data source.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:34:37 GMT

3. Connect the new data source: In the Get Data dialog box, select the type of data source you want to connect to and provide the necessary information to connect to the data source. Click on the Load button to load the data.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:34:54 GMT

4. Replace the old data source with the new one: Go to the Fields panel, right-click on the name of the old data source, and then click on Replace References. Select the new data source from the list and click on Replace.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:35:12 GMT

5. Refresh the report: Go to the Home tab, click on the Refresh icon to refresh the report with the new data.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:35:26 GMT

Note: If you have used the old data source in any calculations, you may need to update the calculations to reflect the changes in the new data source.

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:35:46 GMT

Hope this helps!

Re: Working with live data

Nassren — Tue, 31 Jan 2023 19:38:30 GMT

Do I need a Premium version for this act?

Re: Working with live data

Sahir_Maharaj — Tue, 31 Jan 2023 19:41:53 GMT

As for the premium version requirement, it depends on the type of data source that you are trying to replace with. Some data sources, like SharePoint or OneDrive for Business, can be replaced in Power BI Desktop with either a Free or Pro account. Other data sources, like Azure SQL Database or Power BI Dataflows, require a Power BI Premium capacity.

If my response(s) assisted you in any way, don't forget to drop a "Kudos" 🙂