Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity 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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    But dataset is hidden to Power BI desktop, no? Only is for power Bi service

    • bcdobbs's avatar
      bcdobbs
      Icon for Community Champion rankCommunity 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.

      • bcdobbs's avatar
        bcdobbs
        Icon for Community Champion rankCommunity 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.