Dataflow Error Message not Informative

[mcolb88]

I had a dataflow fail the other day. It contains 4 entities getting dfata form SAP HANA andd SQL Server. When I download the error info from the service I get the following. Which leads me no where. Normally there is a section of JSON data after this message providing a clue. This one has nothing. Also of note, the duration in the refresh history shows 48:44, this downloaded file shows 00:00. 

Requested on	NA
Dataflow name	xxxxxxxxxx
Dataflow refresh status	Failed
Table name
Partition name	NA
Refresh status	Failed
Start time	NA
End time	NA
Duration	00:00.0
Rows processed	NA
Bytes processed (KB)	NA
Max commit (KB)	NA
Processor Time	NA
Wait time	NA
Compute engine	NA
Error	There was a problem refreshing your dataflow.

Is there anywhere else to go to try and get an error message that may lead to understanding why this dataflow failed?

Thanks

[v-henryk-mstf]

Hi @mcolb88 ,

Power BI dataflows are workspace-level objects in the Power BI service. For the above error, you may wish to try to delete the affected workspace from the capacity and add it again or create a new workspace, export the data stream as a JSON file, and import them into the new workspace.

For more detail about any refresh in the list you can click the “download arrow” next to the refresh. This will download a CSV file containing per-entity information for the refresh. If your refresh fails, this is probably the best place to look, and if you reach out for support with a failed refresh, the information in this file will be valuable to share with support personnel.

Power BI dataflows store data in the CDM folder format in Azure storage. CDM folders use text files to store data, and a model.json file to store metadata. You can view the corresponding file information in azure.

related document link or refer to a similar solution:

Solved: Data Flow scheduled refresh triggering multiple ti... - Microsoft Power BI Community

Importing model.json to create a new dataflow – BI Polar (ssbipolar.com)

Premium features of dataflows - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

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