Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Fabric - issue adding destination in dataflow

I created a simple Dataflow Gen2 extracting data from a table. I now want to load this data into Fabric warehouse (which I also created). However I am get the following error: "An exception occurred: The given data source kind is not supported. Data source kind: Warehouse." when trying to add destination in the dataflow. Do you have any ideas what could be the cause?




Post Patron
Post Patron


Can you try to create a gateway and use it from dropdown see if that works?




I am loading into a Warehouse wich is a service inside of Fabric. I do not think gateway is applicable here. (Data source mentioned in the message actually refers to target database)

Super User
Super User

Hey @dnytro ,


I must admit that I do not fully understand your scenario, please explain what your data source is.
For now my understanding is the data source is a table of a Fabric warehouse, and you want to create a table in the same warehouse using a dataflow gen 2, e.g., extracting the distinct product keys of a fact table and creating a product dimension table.




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

The source is an ODBC connection which gets data throug a gateway. That part works fine, I am getting the data. But when I click Add data destination and trying to configure it to be Fabric warehouse, I am getting the above error after selection Warehouse as destination. "Data source" in the error message is probably missleading, it refers to data target, not the source. 


The same scenario with the same source and a warehouse as target worked in a different tenant. I could not figure out the difference.  



Yes, that was my understanding that we don't need to create or use gateway for cloud resources. For me, we had to create a connection for Lakehouse ODBC and use it to resolve the issue. You can try and see if it works for you as well.

Super User
Super User

@dnytro The cause is that it is in preview and stuff just flat out doesn't work.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors