cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rewind
Helper I
Helper I

Access Forbidden - dataset connected to dataflow no longer refreshing

Background:

 

I have a dataflow connected to an on-premises SQL server. The SQL server has be configured in our gateway. The dataflow is refreshing correctly automatically and on demand.

 

I have a dataset (and report) connected to the dataflow. The PBIX file can connect to the dataflow and refreshes on demand in the desktop application.

 

I published this report to a Premium Capacity workspace and setup automatic refreshes for twice a week.

 

Under settings for the data set:

Data source credentials

PowerPlatformDataflows (admin has granted access, credentials are not required)Show in lineage view

 

However, every time I refresh the dataset (whether automatically or manually from the workspace) I am receiving the following data source error

 

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the PowerPlatformDataflows source are invalid. (Source at PowerPlatformDataflows.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"PowerPlatformDataflows"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},{"code":"Microsoft.Data.Mash...
Cluster URI:WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

 

 

 

 Help? 😞 

1 REPLY 1
SivaMani
Memorable Member
Memorable Member

@Rewind Are you using the same credentials in both Power BI Desktop and Power BI Service? The error message says invalid credentials.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors