scheduled data refresh
3 TopicsData refresh
Hello everyone, I don't understang why I can Auto refresh from my old laptop with an out of date gateway but when I configure a new gateway on my new laptop I can't refresh and I get this error. Erreur de source de données: {"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":"TRANSACTIONS_SOURCE"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TRANSACTIONS_SOURCE. URI du cluster: WABI-SOUTH-AFRICA-NORTH-A-PRIMARY-redirect.analysis.windows.net ID d'activité: a363e721-3106-4859-af5e-b509d5616914 ID de demande: 9d9541c3-feb7-9d68-8f57-32925c70e1ce Heure: 2023-07-27 16:26:19Z I ve already check the credentials and the different settings I'm desperate for some help731Views0likes2CommentsTroubles with automatic update of dataset
Hello folks, I'm trying to set up the automatic update for a dataset, so the dashboard I built in Power BI desktop can be automated daily at different hours automatically. The trouble I'm facing is when I go to online service to set this update up, in Datasets ribbon appears the following error: Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh. I think the problem is related to the fact I'm using several API with the same token of authentication for each, because in Data source error it mentions that "at least one data source is missing credentials" but honestly I don't know how to solve it. This mistake only appears in online service because when I update the information on desktop everything runs well. I kindly appreciate any help to solve!Solved4.9KViews0likes11Comments