Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.