cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Use measure from published Power BI dataset in another pbix file

Hello,

I have a pulished dataset with very complicated measures.

I want to query that dataset and use the results in another .pbix file.

I am not able to connect to the first data set - I get an error: 

"The connect live option for this file is disabled because it already contains data from another data source..."

Can I somehow query the first dataset? I don't need live connection, I just want to use the existing measures in my other models.

Thanks!

2 REPLIES 2
Highlighted
Super User III
Super User III

Hi @michaelshparber 

 

Composite models do not support datasets, this means you can link to a dataset in the service as long as that's the only dataset in your model / pbix file.

 

You can create new pbix file and link to your dataset.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Highlighted

@Mariusz thank you, that is what I thought

But maybe there is a workaround?

Maybe I can somehow select/import the data from the dataset using API?

Something?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors