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
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.
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
Yes, these navigation panel/menus not available when you work on power bi service dataflow m query editor. In my opinion, I'd like to suggest you can do query steps on power bi desktop side and copy finished m query code to dataflow editor.
Notice: they do not mean all types of m query function work on power bi service side. New helper functions only available on power bi desktop side and some functions will be blocked due to security reasons.
"Yes, these navigation panel/menus not available when you work on power bi service dataflow m query editor. In my opinion, I'd like to suggest you can do query steps on power bi desktop side and copy finished m query code to dataflow editor."
They are available, they just end up giving you this error
Surely if you do this on the desktop side, I have to do it in power Query editor which then creates another data flow on top of the original dataflow
If I copy the code back in the same errors will occur?
In fact, this not the error, it only notices these feature you working has been limited on your license. For this scenario, I don't think it is impossible to ignore notice messages and using these license limited features.
You can refer to the official document to know what type of operations with required the computed entity features.
I'd like to suggest you do these operations in pbix file to publish to the group workspace to share instead of using dataflow.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.