Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
Why I dont have the option available to Add Data Destionation on DataFlow Gen2?
Solved! Go to Solution.
Have you created and highlighted a query first?
I think you need to select a query before you get the option to create a data destination for that query.
Hi @raybeth
Thanks for using Microsoft Fabric Community.
In addition to @frithjof_v , When you create a Dataflow Gen2 directly you will explicitly need to choose a data destination for your queries. However, if you create a Dataflow Gen2 and the destination is configured then you won't see the "Add Data Destination" option because it's already set. For reference please find the screenshots.
Before configuring data destination: Add data destination option is availbale.
After configuring the data destination: Add data destination option is greyed out.
Could you please recheck once whether the data destination is configured?
If the issue still persists, please do let us know. Glad to help.
I hope this information helps.
Thank you.
Hello all.
Indeed, I was facing the same issue, the "add data destination" option was not enabled... 😞 However, I could kept reading and I noticed that it mentions what has been explained here.
If the data destination is already there, the option will be disabled.
If I remove the existing destination, then the option with the drop-down menu becomes enabled !
All is clear now.
Greetings from Belgium 🇧🇪
Thank you. Yes, the data destination was already set. I was able to find it as shown in the screenshot!
Have you created and highlighted a query first?
I think you need to select a query before you get the option to create a data destination for that query.
Hi @raybeth
Thanks for using Microsoft Fabric Community.
In addition to @frithjof_v , When you create a Dataflow Gen2 directly you will explicitly need to choose a data destination for your queries. However, if you create a Dataflow Gen2 and the destination is configured then you won't see the "Add Data Destination" option because it's already set. For reference please find the screenshots.
Before configuring data destination: Add data destination option is availbale.
After configuring the data destination: Add data destination option is greyed out.
Could you please recheck once whether the data destination is configured?
If the issue still persists, please do let us know. Glad to help.
I hope this information helps.
Thank you.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.