Forum Discussion
Using a binary sample file for custom functions in Dataflow 2 gen
You do not see any queries with errors whilst inside the power query editor ?
You should be able to see the queries with errors. You could hit the "refresh preview" button in the ribbon to make sure that the queries are evaluated using the latest state and see if they're getting any errors.
if the errors are only happening during the refresh, then that would mean that the issue is not with the functions but rather with the destination configuration that you have. I'd recommend removing the data destination to rule out the issue on the destination configuration and doing a refresh - if you don't get any issues then the new error is at the destination configuration and it's a completely new issue than the original that was reported
No error occurs in the queries. I used the Save rows option for each query to check it and the result was an empty table.
After I removed the destination configuration it updated successfully.
But when I turned on staging in the query with the resulting tables the error ocurred (while updating, not in the query):
Mashup Exception Expression Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: Couldn't insert table., InnerException: Can not convert a Table type into a Text type.
Do I get it right that staging is not a necessary option and it is for updating optimisation?
Сan I disable it without heavy losses for the dataflow?
Other dataflows are connected to Lakehouse destinations (each dataflow to its Lakehouse).
Could you tell how to create a Lakehouse and correctly connect the dataflow to it?
In the Lakehouse that I connected to the queries of dataflow I found the error:
The SQL analytics endpoint could not be created.
The conversion error more than likely happens because you have a column that contains a table type whereas the destination expects a text or the conversion that you have for such column couldn't convert a table into text
I thoroughly examined the query I assigned the Lakehouse destionation in, there are columns only of three types: text, dates and numbers, and I do not see any conversion of table type into text type. I created a new empty Lakehouse but anyway until I assign the destination the query updates successfully, then the error occures: Can not convert a Table type into a Text type.
Ask you to help me with that question.I'm unable to repro your scenario. If you have a way in which I could repro it with a given sample and / or public data source, please do share it.
otherwise, I'd recommend raising a support ticket so the support team can help troubleshoot and look at this scenario much deeper. Below is the link to open a support ticket: