Forum Discussion
Helper VCreate Dataflow from Power BI Dataset
Hi Suhel_Ansari
You can not build a dataflow on top of the dataset, you can only do it the other way round.
The easiest way I know to replicate the models is by coping the M script from PBI desktop advanced editor into dataflows.
You can still reference the same tables in dataflows, you just need to make sure "Enable Load" is not on.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
You can do this through 'Azure Analysis Services' connector in Dataflow. You will need to do three things:
1. Server: powerbi://api.powerbi.com/v1.0/myorg/{Workspace name}
2. Database: {Datset name}
3. DAX Query: Prepare DAX query using report builder or DAX Studio.
I have detailed this here: https://sites.google.com/view/powerquerywizard/get-semantic-model-data-in-dataflow-in-power-bi
Upvote if you found this solution working for you.