Power BI deployment pipelines with Dataverse

[ojstocholm]

I have set up a three-step Power BI deployment pipeline. 

I use Power BI Desktop to create the Power BI reports, deploy to DEV and use the pipeline to deploy further down the line.

My Power BI report uses Power Platform Dataverse as data source, and I was under the impression that I could configure the STAGING (and PROD) environments to point to e.g., our Dataverse STAGING environment as well as our Dataverse PROD environment.

However, when I have deployed to STAGING and click the little "Lightning" icon

... to set up a Deployment Rule ... 

Everything is grayed out.

Can anyone tell my why this is happening? And even better: can anyone tell me how to configure my STAGING workspace to have the data connection for this report point to the right data source?

Thank you

/Jesper 😊

[ojstocholm · Accepted solution]

I fixed my problem with a couple of steps.

First, I use parameters in my Power Query to point to specific API endpoints, so I am using the "Parameter rules" to configure those.

Second, I have configured the "Data source credentials" in each workspace to have the correct credentials for e.g., STAGING and PROD.

I guess that the conclusion is that I did not need the "Deployment rules" for Dataverse connections. And if I had no parameters configured, I would have to just edit the credentials for the semantic model in each workspace.

[cwarnholtz]

Did you ever get an answer for this? We are having the same problem with the Dataverse Connector...no deployment rules available!!!

Thanks,

Craig

[ojstocholm]

Hi @cwarnholtz I have added my solution to this thread. I hope that it helps.

/Jesper