Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

"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
Anonymous
Not applicable

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
GilbertQ
Super User
Super User

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

Anonymous
Not applicable

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

Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors