Forum Discussion
Data refresh fail !
Hi adminBM ,
There is no parameter to ignore fail queries. Please try to use Enable Load.
If we disable the option "Enable Load" for the query, when we apply the change, this query table data will not be loaded to data model. But when we refresh the dataset, there is also a query sent to data source. See: https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up
When we disable the "Include in Report Refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop. It does nothing to the power BI Service.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
adminBM , You are missing column1 DealHistory table, check that.
Or open Power Query and correct the column
Hello amitchandak , thanks for your response. For a specific database, with empty table DealHistory, the API return null and so POWERBI don't find the column. For others database, no problem, the table is not empty so the api return the column. So i want to ignore this query when there is a problem and not block the others queries ( I don't have the possibility to change the API ). So i don't know if in PBI there is parameter to ignore fail queries ?