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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RakeshSinghr
Resolver I
Resolver I

Power BI Dataflow Limitation

Dataflow usage in datasets

  • When creating a dataset in Power BI Desktop, and then publishing it to the Power BI service, ensure the credentials used in Power BI Desktop for the Dataflows data source are the same credentials used when the dataset is published to the service.
    1. Failing to ensure those credentials are the same results in a Key not found error upon dataset refresh

 

Based on this existing dataflow limitation, is it not possible to publish and refresh dataset using service principal?

Refresh fails with error - atleast one datasource is missing credentials, enter credentials for all datasources

 

Once published, i can see datasource with following details

 

ConnectionType: Extension

ConnectionDetails: path:PowerBI

                               kind:PowerBI

Gatewayid: xxxxx ( this seems to be a default/inbuilt gateway)

 

Anyone using dataflow in their dataset come across this issue?

 

2 REPLIES 2
v-cazheng-msft
Community Support
Community Support

Hi @RakeshSinghr 

You can publish report and set refresh on the dataset. Please Map data sources in this dataset to Power BI and Apply it. And check in Data source credentials to make sure there are no credentials problem.

v-cazheng-msft_0-1620811970526.png

 

v-cazheng-msft_1-1620811970577.png

 

v-cazheng-msft_2-1620811970582.png

 

If you still have questions, please let me known.

 

Best Regards

Caiyun Zheng

 

If this post helps, please consider make it as the solution by Accept it as Solution. Really appreciate!

@v-cazheng-msft - are you saying that a dataset using only dataflow should still be configured to use gateway and set to Power BI?

 

How do you update credentials programatically? i'm using service principal

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors