Dataflow Edits Won't Save

[pawlowski6132]

Can't save dataflow

Linked entities can't be modified. Please undo any changes made to the following linked entities and try again

I'm connecting to an existing dataflow. I get this error, after minor edits, when creating a new dataflow or a linked dataflow.

This seems like a very simple thing to do. What could I be doing wrong???

jrp

thank you in advance for your assistance

[Anonymous]

Hi,

I just ran into the same issue, it looks like linked entities used in a dataflow are "read-only".

To add transformation steps, you will need to first create a reference to the linked entity then modify the reference, and eventually disable load of the original linked entity.

Hope it helps!

Nicolas

[pawlowski6132]

Hmm. Thanx for the reply.

Do you have example of how to create a reference? I can't imagine how to do that.

Also, can I assume that we would not have to disable the load of the original linked entity? Can we keep them both?

[v-xicai]

Hi @pawlowski6132 ,

There is a similar case reported in Issue forum you may refer to : Unable to save a dataflow . Or you may update the on premise data gateway to the latest version to avoid potential issue. 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[quyenduong]

Hello Amy,

I have a data flow connecting from weeky xlsx data files. Then I build a dataflow for these data. Whenever I do some transformation steps in the data flow (create new columns, change data type, extract characters from one column to create a new columns, change columns order, etc.), the table that I connect with Power report (Desktop) shows an empty table.

Now, I leave data flow without any transformation and connect it to datamart: I transform the data in datamart. It also cannot save and show some error message 

When I leave dataflow without any transformation and then connect data flow into power bi desktop, then transform all data in desktop and it works.

Do you know why it is like that? We cannot transform data in data flow or data mart?? Thank you for answering