Datamart Error 500 when using dataflows

[NickRobinson]

Hi,

We are receiving an InternalError code 500 whenever we update a datamart linked to dataflows.

We can create a datamart with many dataflows and this works fine. The dataflows update fine and then the datamart updates ok.

The issue appears to arise when we either amend a dataflow (i.e. we add a new column) or try to add a new dataflow to the datamart.

The error message says "An internal error happened due to failed runtime assertion: Entity <ccon>Analysis Dim</ccon> type Microsoft.Dataflows.ObjectModel.ReferenceEntity is not local."

Any ideas on how to resolve this ?

[tsnyd111]

I'm getting this same error with Dataflow. Once I initially load, if I go back to adjust the queries, I'll get the 500 error others have mentioned. 

[Vhae0410]

Having the same issue after adding a new column to the one of the dataflows. No issues with the dataflows. However, when I refresh the datamart the error 500 appears. When I go to transform data in datamart, I can see the new column. There are no errors in any of the steps.  What is the resolution for this?

[rossrhunter]

I'm getting the exact same errors when I try to add more dataflows to my datamart. It does not matter which type of dataflows I try to connect - if I try to add more, I will get this same error

[NickRobinson]

Thanks @v-yinliw-msft ,

Yes, all the dataflows are working well and can be refreshed and connected to without any problems.

The error appears when connecting a dataflow after the initial Datamart creation (i.e. I create a datamart with two dataflows and it will work but if I then try to add a third it then gives this error.. it does not matter which dataflows I create the datamart with initially or which dataflows I later add) or when a dataflow is updated with additional columns.

[v-yinliw-msft]

Hi @NickRobinson ,

You should to confirm that your dataflow is OK.

If you use this dataflow as a data source to create a new datamart, will you receive an error same to this?

And please confirm the dataflow you use that the model in them  you can connect it correctly.

Best Regards,

Community Support Team _Yinliw

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