cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

"CredentialMissing" after copy report and publish with new name ?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Hi there

It appears that you need to configure the credentials for your copied report under the settings and then dataset?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted

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)

kjellmafa_0-1600417462376.png

 

Highlighted

Hi there

As per the message you need to update the credentials in your dataset for the report you copied.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted

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

Highlighted

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors