cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sau001
Helper IV
Helper IV

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!

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

@sau001 

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 II
Super User II

Hi @sau001 ,

 

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.




Hi @collinq ,

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

Did you have New-PowerBIReport cmdlet in mind?

 

Thanks,

Sau

 

 

 

 

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.

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!

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates