Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to change the data source of a report which consumes an online Power BI dataset to another

Hi All,

 

Please consider the following scenario:

 

My company is on Professional edition.

We envisage several Power BI reports which are developed around a single Power BI dataset (Dev-Dataset) . These are all in the Dev-Workspace.  

sau001_0-1617198127711.png

 

After testing and user trials, I would like to copy over these reports to a Prod-Workspace and  have them point to the production Power BI dataset (call this Prod-Dataset)

sau001_1-1617198836503.png

Doing this manually ?

  • I will have to download the PBIX of Report1, Report2 and Report3 
  • Open using Power BI desktop
  • Re-point the data source to Production
  • Re-publish from Power BI

Automating the above?

Is it possible to automate the movement and re-pointing from Dev to Pro using some tool or scripting such as Powershell ?

 

The manual steps are too many and error prone.  We want to make the development process more productive because we need to do this for every sprint cycle.

 

Thank you,

Sau

 

 

 

 

 

10 REPLIES 10
_sfrost
Solution Specialist
Solution Specialist

I believe it's the concept of Deployment Pipelines, a newly introduced feature in Power BI

 

_sfrost_0-1617678323663.png


You can automate the process of pushing the content from Development > Test > Production with few clicks.

 

Please refer to the below doc if that helps:

Deployment pipelines overview - Power BI | Microsoft Docs

 

Remember this is Premium Only feature.

 

Please accept this answer as solution if in case my suggestions helped you!

Anonymous
Not applicable

Hello @_sfrost ,

I did consider this.  Our licenses are Professional at the moment. At our current scale of operations, I cannot see us paying hefty premium fees.

 

Thank you.

 

_sfrost
Solution Specialist
Solution Specialist

@Anonymous 

Then I'm afraid the only possible way I can think of right now is to udpate the source manually. 

You can upvote the below idea incase if you would like to see this feature available for Pro users.

Microsoft Idea · Power BI deployment pipelines (Preview) for Pro users

 

There might be another option you can investigate further (haven't tested it. I just think it's worth a try)

We can actually automate few kind of Power BI Actions with Azure DevOps in combination with Power BI REST APIs and PowerShell cmdlts, as explained in the below community forum:

PowerBI - CICD using Azure DevOps - Microsoft Power BI Community

collinq
Super User
Super User

Hi @Anonymous ,

 

There is not a really clean way to do that as far as I know but you can no doubt create a Power APp or Power Automate or even PowerShell to do this.  However, I think it would be easier and quicker to change the source to use a Parameter.  You would have the initial setup time but after that it would be just changing one Parameter per report to point to the new datasource. 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

Hi @collinq ,

You mentioned that PowerShell cmdlets might help in automating this task?

Did you have New-PowerBIReport cmdlet in mind?

 

Thanks,

Sau

 

 

 

Anonymous
Not applicable

 

I wonder if the REST end point 'Rebind report in Group ' can do the trick.

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup

 

_sfrost
Solution Specialist
Solution Specialist

There is this REST API for updating data source. 

Datasets - Update Datasources In Group (Power BI Power BI REST APIs) | Microsoft Docs

 

But that doesn't list the Power BI Dataset as source in the list of supported data sources.

Anonymous
Not applicable

Hi @collinq ,

 

I did make an attempt at creating a parameterized report where the parameter points to another Power BI dataset which has been published on Power BI service.

 

However, I was unable to find any UI option that would allow me to do that. Here is a screen capture of a report immediately after selecting an online Power BI dataset as a data source.

 

sau001_0-1617657146266.png

You can see that the parameters options have been grayed out.

 

Thank you,

Sau

 

 

 

 

_sfrost
Solution Specialist
Solution Specialist

March 2021 Power BI Desktop Version supports Direct Query for Power BI Datasets. May be you can try that check if you can see parameters option enabled?

 

Make sure to enable this option in Preview Features in case if you are trying!

Anonymous
Not applicable

Hi @_sfrost ,

 

Just checked once more. I am on March 2021 version

sau001_0-1617699345554.png

 

Preview feature turned on

sau001_2-1617699688288.png

 

The parameter options are grayed out.

sau001_1-1617699424908.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors