Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
iBusinessBI
Kudo Collector
Kudo Collector

Import from other Dataset based on a DAX Query

I have a dataset with complex measures.

I need to get these measures to another Destop model.

When I try to connect via Direct Query - it is very slow.

So I tried to create an intermediate table in Dataflow that would have just two columns: Date and Metric Value - these are the only columns that I need. 
But I don't see a possibility to connect to a Dataset via Dataflow.

How do I import a table from my Dataset?
I've heard about REST API, but is it possible to do this in Dataflow only? (without Power Automate?)
Other options?
Thanks

1 ACCEPTED SOLUTION
iBusinessBI
Kudo Collector
Kudo Collector

1 REPLY 1
iBusinessBI
Kudo Collector
Kudo Collector

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.