bizarre datasources "extensionDataSourceKind" appearing in simple sql ingestion dataflow

[frano72]

Hi, I have an ingestion dataflow that connects to an on premise sql server view and incrementally refreshes.

However there are these weird data sources referenced for my dataflow - that I can't see referenced anywhere in the dataflow power query editor.  I exported the dataflow to json to see if they were referenced in there...nope, not even.

From project options in the dataflow - the gateway is correctly configured.

But if I go into settings to view the gateway setup - it shows this.

How do i get rid of these bizarre entries ?

[v-yanjiang-msft]

Hi @frano72 ,

Did my solution solve your problem? If yes, please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @frano72 ,

By my reserch, this problem often occurs when dataflow is used as the data source，the solution is often related to the gateway, you can try to enable "Allow user's cloud data sources to refresh through this gateway cluster" in your gateway cluster settings .

These problems are similar to yours, but the solutions are different. You can refer to：

Solved: Re: Gateway extenionDataSourceKind Power BI error - Microsoft Power BI Community

Solved: Issue adding "PowerBI" (dataflow) source to an ent... - Microsoft Power BI Community

Solved: Re: dataflows: Extension("extensionDataSourceKind"... - Microsoft Power BI Community

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Looks like you played with the Machine Learning options for the dataflow?

[frano72]

@lbendlin - hey....yeah i played with it.  But didn't set anything up - so there is nothing to "undo" it from what i can see !