Hi, I published powerbi datasets and used them in another powerbi report so each connection is a direct query. I am not able to refresh the underlying datasets without getting an error - I have my private gateway set up and also signed in with all my credentials. The datasets refresh with no error in Desktop, only in the online service I am getting this error:
Last refresh failed: 10/3/2023, 12:07:19 PM
There was an error when processing the data in the dataset
| 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":"Information is needed in order to combine data. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"C:\\\\Users\\\\x264885\\\\Documents\\\\Quantum\\\\Updated PC Split 9.26.23.xlsx\"},{\"kind\":\"File\",\"path\":\"P:\\\\Oracle\\\\Income Detail\\\\2023\\\\3Q2023\\\\GAAP\\\\Source Files\\\\Oracle Income Detail Report (Actuals Only) wSOE - GAAP.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: ALM Oracle Income Detail. |
| Cluster URI: | WABI-US-NORTH-CENTRAL-D-PRIMARY-redirect.analysis.windows.net |
| Activity ID: | 17c02a4b-8291-4173-8942-3f937976d5c2 |
| Request ID: | dec5fe4b-1122-337f-d6ea-d31530339647 |
| Time: | 2023-10-03 16:07:19Z |
