I have created a report connecting to a BigQuery data source through a credentialed service account with Simba ODBC driver. The report refreshes in Power BI desktop with no issues. However for the same report, I am facing intermittent scheduled refresh errors on the Power BI Service, The refresh may be successful 4 or 5 times and then fail 2 to 3 times then come back to a successful refresh without any changes. Can anyone suggest the probable cause and ways to get arounf this problem.
Data Source Error :
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The table has no visible columns and cannot be queried."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"ap_abc"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: ap_abc.
Thanks,
