Forum Discussion
Report refresh failure when published in new workspace
These messages point to a culprit outside of Power BI's control. Talk to your Vertica DBAs.
What you referring to is the parallel load of tables from your dataset's data sources. Say you have one dataset with five SQL server tables, each pretty large and maybe even with complex filters.
If these tables all reside on the same server then yes, preventing parallel load WILL help. But if they reside on different SQL servers then it doesn't really matter.
In you refresh failure error message you should find the reason for the failure. It could be a simple timeout, or it could be that one of the requests has been selected as the table lock victim if both datasets point to the same table, or if your data retrieval coincides with data updates etc.
Post the refresh error message for BOTH datasets.
Thank you lbendlin for your quick response. Even though error shows "it ran out of memory trying to run the query" but, if I publish the reports manually it takes less than a minute to publish in power bi service.
All Reports have the same datasource Vertica (ODBC connection), here is the error message -
Dataset 1 -
Dataset2-
Dataset2 -
These messages point to a culprit outside of Power BI's control. Talk to your Vertica DBAs.
Thank you lbendlin. I'll do that. I really appreciate your help, thank you!