Connecting to PBI Service Dataset

[Anonymous]

Hi Guys,

My organisation is connecting to a PBI dataset, which feeds about 10 different reports.

This PBI dataset itself is just a normal PBIX file with the data model.

We also have a setup where we have a Dev workspace, a Test workspace and a prod workspace.

My question is - is it possible to parameterise a PBI dataset connection?

So one of the reports that are connected to a DEV PBI dataset can connect to the Test version of the PBI dataset via a parameter.

I can't seem to access Power Query when connecting to PBI Service datasets.

Thanks

Oneiricer

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

Due to the connection mode is live connection, you can't use PowerQuery Editor and parameter function. And you can't get more data from other datasets. You may try to get data directly from local computer or try to saving your data in Azure Analysis Service, and get data.(Import except live connection)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Tahreem24]

@Anonymous ,

I got some similar thread like your query:

https://community.powerbi.com/t5/Desktop/Managing-Dev-Test-and-Prod-Environments-in-Power-BI-Desktop/td-p/489077

https://debbiesmspowerbiazureblog.home.blog/2020/02/05/moving-power-bi-to-different-environments-dev-test-production-etc/

I hope it may help you.

[amitchandak]

@Anonymous , I doubt you can do much with power bi dataset, the Only visualization is enabled.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets