I can refresh the pbix file on the desktop without problem, then publish
when I setup using the schedule refresh, it come up with the following error
I have 2 questions
1. how to make no changes or minimal changes to make it work on the schedule refresh
2. Is there any do or don't that we can follow, to eliminate the problem.
[other pbix file work on the schedule refresh without problem. therefore, I believed the setup is correct.
the specific pbix file contains alot transformation and DAX and dependency on the query]
----------------------------------------------------------------------------------
Last refresh failed: Tue May 05 2020 23:31:15 GMT+1000 (Australian Eastern Standard Time)
There was an error when processing the data in the dataset.Hide details
| 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":"[Unable to combine data] Section1/Invoice_Summary All/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Odbc\",\"path\":\"dsn=BLP800CFBL\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}} Table: Invoice_Summary All. |
| Cluster URI: | WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net |
| Activity ID: | 99258639-d31f-4411-b20b-13f71790650e |
| Request ID: | 536b5959-c940-4e1a-ab10-967db6ddd1b2 |
| Time: | 2020-05-05 13:31:15Z |
