Forum Discussion
Connecting to PBI Service Dataset
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
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.
4 Replies
- amitchandak
Super User
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
Tahreem24Anonymous ,
I got some similar thread like your query:
I hope it may help you.
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.
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
