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.
Failing to ensure those credentials are the same results in aKey not founderror 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
Gatewayid: xxxxx ( this seems to be a default/inbuilt gateway)
Anyone using dataflow in their dataset come across this issue?
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.
If you still have questions, please let me known.
If this post helps, please consider make it as the solution by Accept it as Solution. Really appreciate!