cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
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

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

 

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

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

View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors