Forum Discussion
Dataflow Failed to save
Hi everyone,
I'm receiving the following error:
Power Bi Dataflow error
I'm trying to load data from Oracle server. There are no issues with the query. When i load the top 5 rows, it works fine.
I think, the issue is with loading larger dataset. Anyone facing this issue?
Hi dataguy-ali ,
Have you ever checked if there is any data type mismatch in your query? Sometimes, Power BI might not show NaN as an error in the error table. You could use the syntax in Power Query to handle these errorstry otherwise.
As you said，If the dataset is too large, Power BI might struggle to load it all at once. You could try loading the data in smaller chunks or consider using Power BI’s on-demand loading capabilities for large models.
You may also need to make sure your data source credentials are up-to-date. You can reauthenticate your data source by going to your Power BI dataset in Power BI Service and clicking on “Data source credentials” or "Edit credentials".Best Regards,
Community Support Team _ Caitlyn
2 Replies
Hi dataguy-ali ,
Have you ever checked if there is any data type mismatch in your query? Sometimes, Power BI might not show NaN as an error in the error table. You could use the syntax in Power Query to handle these errorstry otherwise.
As you said，If the dataset is too large, Power BI might struggle to load it all at once. You could try loading the data in smaller chunks or consider using Power BI’s on-demand loading capabilities for large models.
You may also need to make sure your data source credentials are up-to-date. You can reauthenticate your data source by going to your Power BI dataset in Power BI Service and clicking on “Data source credentials” or "Edit credentials".Best Regards,
Community Support Team _ CaitlynThank you for your response. There was no error after all. The issue was due to the complexity of the query. Power BI Dataflow couldn't load larger datasets into the dataflow. After optimizing and limiting the dataset, the error was resolved.
