Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a dataset which I created in PowerBI desktop and published to PowerBI Service. The model consists of data from an ODBC database as well as GSheets and gets refreshed via an on-premise data gateway regularly. Now I would like to add local Excel Files to the dataset. It works just well when adding the files to the dataset in Microsoft Desktop. When publishing though I am getting the error below. I do understand there are some issue with the path / login credentials but I don't know where to add them. Would be much appreciated if anyone could guide me how to add excel files to the data model and make the refresh work in PowerBI Service. The excel file is btw. stored on the same server like the ODBC database.
Let me know if you require any other information.
Many thanks for your help!
{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Die für die Quelle \"File\" bereitgestellten Anmeldeinformationen sind ungültig. (Quelle unter \"m:\\orla2_löseral\\logistik\\kosten\\tourenübersicht_it.xlsx\".)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"File"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"M:\\Orla2_Löseral\\Logistik\\Kosten\\Tourenübersicht_IT.xlsx"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"M:\\\\Orla2_Löseral\\\\Logistik\\\\Kosten\\\\Tourenübersicht_IT.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: f_Tourenuebersicht_IT.