Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

Issues with Dataflows for Power BI Pro (Computed Entity) on Merge

I need to create a decent data model in Power BI dataflow using the source data.

 

To do this I need to merge Tables to put the IDS into the central fact table. However it appears that you cant merge tables. When you do it creates a computed entity and you have to have power BI Premium

 

At the moment I have no other option than to do it without updating the data source and I currently have no idea how to get around the issue within the dataflow.

 

All I can think is to move the dataflow back into the pbix file which defeats the object of me telling everyone how great using a dataflow is.

 

Im really struggling at the moment to come up with a way round this, staying in the dataflow. I need to use merge to create a decent dataset with ID Links

Need Help

9 Replies

  • RakeshSinghr's avatar
    RakeshSinghr
    Icon for Resolver I rankResolver I
    6 years ago

    Hi,

     

       Dataflows are great for having all your data in one location in azure that is refreshable.

     

    Having created entities in dataflow- Create the model to built star schema within PBI desktop by connecting to Dataflow:

    get data - > Power BI Dataflows.

     

    Once you have loaded your entities in your PBI desktop file, you can model it as if it were sql server tables.

    You can then publish to PBI service to create a dataset built on PBI dataflow.

     

    Regards

    Rakesh

    • DebbieE's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion
      6 years ago

      thats just not good enough to be honest.

       

      I need to do lots of things before moving to the model which require merging tables and pulling data items from one table into another.

       

      there is some more complex logic that requires duplicating a table and merging data items. Without the ability to merge Power BI Pro is just not fit for purpose. Ive spent a lot of time telling people that dataflows are the way forward but losing this crucial function is basically stopping me from doing the work,

       

      It really looks like I will have to go back to creating the flow in the desktop. I need either a workaround or I think I need to raise a ticket or something. This is extremely disappointing

       

       

      • RakeshSinghr's avatar
        RakeshSinghr
        Icon for Resolver I rankResolver I
        6 years ago

        Data wrangling - use dataflow M script

         

        Data Model - use Power bi desktop