Dear Community,
I hope someone can help me with an issue I am facing whenever I try to publish a dataflow at the Dataverse and I am getting always the same error... The problem is when I publish, when refreshing, I get the following error:
Knowledge Base,KB content,1/31/2023 11:01:22 AM,,Failed,"Error Code: Mashup Exception Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert a value of type Table to type Text. Details: Value = #table({""http://schemas.microsoft.com/ado/2007/08/dataservices/metadata""}, { }) (Request ID: 2798c763-e232-4ecf-bad7-346dfc74d12b)."
I've tried to redo the query in several ways but I always come up with the same error message. Are there any limitations in the Dataverse / Dataflows that I'm not aware of?
Due to size restrictions I will share my query in a link:
https://docs.google.com/document/d/17XkFrrEG2jhabEp-Ht4xPZmRZxf-UYIdVlg8zF84240/edit?usp=sharing
I appreciate any help solving this issue! Many thanks!
