Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Något gick fel
Ogiltiga autentiseringsuppgifter för anslutning.
Försök igen senare eller kontakta supporten. Om du kontaktar supporten, så tillhandahåll följande information.
Underliggande felkod: -2147467259
Underliggande felkodsmeddelande: Credentials are required to connect to the SQL source. (Source at sql01\jeeves;mafa.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SQL
Microsoft.Data.Mashup.CredentialError.DataSourcePath: SQL01\JEEVES;mafa
After i have done a copy of a report and published to the same workspace - i got this error messages
// Kjell
Microsoft.Data.Mashup.CredentialError.DataSourceReference: {"protocol":"tds","address":{"server":"SQL01\\JEEVES","database":"mafa"},"authentication":null,"query":null}
Microsoft.Data.Mashup.CredentialError.Reason: CredentialMissing
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"SQL01\\JEEVES;mafa"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: CredentialMissing
Kluster-URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Aktivitets-ID: 18e1780c-0122-4dc7-ab07-090a433c0d71
Begär ID: 33fb3386-13bf-8957-3645-cc740fd53638
Tid: 2020-09-17 18:29:44Z
Solved! Go to Solution.
Hi, got a tip on this article - see link.
After following these instructions, my reports will work again.
https://slavasql.blogspot.com/2019/05/powerbi-schedule-refresh-error.html
// Kjell
Hi. I have now checked this, and I have "successful connection" with the gateway during data sets.
But unfortunately I get the same message when the report is run.
Works flawlessly in "Desktop"
FYI_I was only minor changes to report before "SAVE AS"
// Kjell
(se attached clip - after trying to uppdate dataset)
Thanks for your answer. Now I have updated the permissions in desktop / data sources (is an account that has access to the current sql server). In Power BI service online I now have the same account as in desktop under "manage gateways". When testing, the answer is "connection succeeded" the gateway is up and running on the computer it is installed on in the same domain (marked with green text), but unfortunately the same error message again ..!?! // Kjell
Hi, got a tip on this article - see link.
After following these instructions, my reports will work again.
https://slavasql.blogspot.com/2019/05/powerbi-schedule-refresh-error.html
// Kjell
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.