Dataflow (preview): Authenticating error when using sql and web connector (SPO) in same dataflow

[Anonymous]

So I've created a dataset that directly queries a SQL server database and also connects to a Dataflow. However, I'm not the owner of the dataflow. When the original owner of the dataflow takes over the dataset, he is able to refresh the database. I have ownership priviliges in the workspace. However, when I try to refresh the dataset, I receive the following error: 

Data source error:

The credentials provided for the PowerBI source are invalid. (Source at PowerBI.). The exception was raised by the IDataReader interface. Table: Dataflow Table.

It seems the credentials to the dataflow are incorrect. However, I have full ownership priveliges in the workspace, so I should be able to refresh it. Any thoughts on how to fix this? 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, I cannot reproduce your issue here. After saving the dataflow with these two entities, the dataflow can be refreshed successfully by the admin users in the workspace. BTW, the on-premises data gateway version is 3000.2.52. Please update the gateway and try again.

Please notice here I used the Web API connetor when connect to SPO.

[v-frfei-msft]

Hi @Anonymous ,

Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.