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 wit...
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.
But dataset is hidden to Power BI desktop, no? Only is for power Bi service
No if you click Get Data in power bi and then dataset, you can connect to any power bi dataset you have access to.
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.