Power BI Embedded: DMTS_DatasourceHasNoCredentialError

0 votes

So, I'm attempting to create a PBIX file in PowerBI Desktop using DirectQuery method on Azure SQL Server, followed by which, I uploaded the file to the workspace. Now when I try to open that report on my custom web app using MVC API, it throws the following error at me;

"The data source has no credentials. Please try again later or contact support and provide the following details to help resolve your issue faster."

Error CodeDMTS_DatasourceHasNoCredentialError
Server someserver.database.windows.net
Correlation ID3b3d08d7-21cd-7a4b-3778-79841050d3c4
ConnectionType {FieldValue}
Activity ID24480fac-d172-e3a6-17b6-eb8a2ce5b02c
Request IDb1ec1b45-5a65-c642-3fa0-4c5090102720
TimeFri Jun 10 2016 14:53:01 GMT+0500 (Pakistan Standard Time)
Version13.0.1500.198
Cluster URI https://wabi-south-east-asia-redirect.analysis.windows.net/
Apr 10 in Power BI by Upasana
• 8,530 points
59 views

1 answer to this question.

0 votes

You'll need to call the PATCH data source API Patch Gateway Datasource API.

When you import your PBIX file into your Power BI workspace collection on Azure the service does not include your credentials due to security concerns. After your import is complete you can modify the credentials and connection strings using the REST APIs.

Power BI REST APIs

answered Apr 10 by Shubham
• 13,290 points

Related Questions In Power BI

+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,070 points
114 views
0 votes
1 answer

Is it possible to manage limits while using dedicated capacity power bi embedded app service?

These limits are not related to using ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,070 points
63 views
0 votes
1 answer

.Net Core 1.1 : Power BI Embedded

Hope this might be of some help ...READ MORE

answered Dec 27, 2018 in Power BI by Upasana
• 8,530 points
35 views
0 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23 in Power BI by anonymous
• 25,660 points
26 views
0 votes
1 answer

Applying multiple filters in PBI Embed URL

Well, that is actually a limitation in ...READ MORE

answered Aug 21, 2018 in Power BI by DataKing99
• 8,130 points
649 views
0 votes
1 answer

Embed URL-multiple filters in Power BI

With the release of 2.0.0 you can ...READ MORE

answered Oct 16, 2018 in Power BI by Annie97
• 2,190 points
886 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

answered Oct 23, 2018 in Power BI by Annie97
• 2,190 points
1,039 views
0 votes
1 answer

Power BI Embedded : Importing Packages

This should help you out. https://www.nuget.org/packages/PowerBI.Ne ...READ MORE

answered Apr 3 in Power BI by Shubham
• 13,290 points
22 views
0 votes
1 answer

Can I get rid of the grey border on the report visuals with power bi embedded?

You can do the following to make the ...READ MORE

answered Apr 10 in Power BI by Shubham
• 13,290 points
259 views