Forum Discussion
linked objects (Dataflow tables) transformation
Create and Transform a Power BI Dataflow Using Other Power BI Dataflow
Go to Power BI Service and then to your Workspace
Click New Item and then choose Dataflow and click on Add new table and the select Power BI dataflow (Legacy) It will ask you to validate or change your authentication kind. By default it should have Power BI - > Now click Next
Once inside, you should be able to enter an interface where you'll find all the Power BI dataflows you have access to. Expand them and choose the desired tables from under them and proceed to transform data
This will open the desired table in a Power Query Editor.
However you will soon discover that you're not able to modify the table as the source dataflow appears into your dataflow as a Linked table. Power BI wouldn't let you modify linked table to maintain
"single source of the truth".
What you can do is create another table as a reference to this linked table and do you transformation on this reference table.
Finally don't forget to refresh this reference table before consumption and set-up scheduled refresh on this the refrence table
2 Replies
Hi, avishek_g
Many thanks for sharing this. It'll help more people find it more easily.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you for this tutorial. I have tried this. However, the dataflow can't be saved unless you first disable the linked table's ability to load. Hence, the transformed reference table will not be able to refresh.
