Forum Discussion
Measures in dataflows
Hello,
I'm creating a dataflow in Power BI service.
Once I have the dataflow, I would be interested in being able to create measures within the dataflow that when connecting a power BI desktop with these flows, I would like the measures aqlready created. Is there any possibility for this?
Thanks in advance
Afraid data flows won't do that for you.
What you want to do is consume the data flow and publish a dataset which contains all measures and business logic. This can then be used by other reports.
5 Replies
- bcdobbsCommunity Champion
Afraid data flows won't do that for you.
What you want to do is consume the data flow and publish a dataset which contains all measures and business logic. This can then be used by other reports.
- bcdobbsCommunity Champion
- AnonymousNot applicable
But dataset is hidden to Power BI desktop, no? Only is for power Bi service
- bcdobbsCommunity Champion
No if you click Get Data in power bi and then dataset, you can connect to any power bi dataset you have access to.
- bcdobbsCommunity Champion
Have a watch of
https://m.youtube.com/watch?v=OH6aekIjcUI
In short you can build a report in power bi desktop that just has the data and measures etc. If you publish that to the service you can delete the "report" bit leaving just the dataset.
That dataset is then available to consume in power bi desktop.