Forum Discussion
Error creating or editing Dataflows
Whenever I try to create a dataflow it gives me "unexpected error" during the data load part with no mayor explanation. Nonetheless, my colleague can create the same Dataflow with no issues. Finally when I try to edit the dataflow of my colleague a I get error and can't save any modification.
I have tried different browsers and computers with the same results.
8 Replies
Hi Anonymous ,
Are you unable to create dataflows for all data sources or for a specific data source?
Are you unable to create dataflows in all workspaces?
Is there any error message in the bottom left corner when editing the dataflow?
Best Regards,
WinnizHi, that's a good question, I tried and I'm able to create dataflows from OneDrive.
The ones I need to create are connections to a Sharepoint Folder, for which I am getting the error. The unexpected error happens after I try to merge files in a sharepoint folder, after showing me the data and transformations, when I click load the table, it shows the unexpected error. After that it just shows me loading data and never ends.
Hi Anonymous ,
I cannot reproduct your problem, this is my test.
1. My datasource is OneDrive for Business, use the SharePoint connector. Go to OneDrive and grab the URL. It will look like this:
Then combine and merge files, no errors were generated.
There is workaround: copy & paste the main query code from the Desktop advanced editor to the dataflow, copy the query code from the custom function for combining files from the Desktop advanced editor and somehow work it into the main M code in the dataflow.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
There was a major issue today with the same error messages. I can't find the threat right now, but MS should work on that at this moment.
If I find the link, I will add it here.Hi Anonymous ,
The issue should be fixed. Try it in your workspace.Hi Migasuke, thank you for following up. I tried today and I'm still experiencing the same issue. I can't create or edit Dataflows.
For reference the error always happen after I do the data transformtions and load, or when I try to save an already existing Dataflow.
