Forum Discussion
Export Query Results - Unable To Fetch Data Destinations
Could possibly be a useful feature anyone able to get this to work?
Thanks,
w
6 Replies
tecumseh , Every time you click if creates on Dataflow Gen 2 on the service. Seems like a bug with the message . Seem like a bug. Please log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues
Hello tecumseh ,
This is a preview feature and to use this feature you need access to Microsoft Fabric and also your My Workspace must be assigned to a Fabric or trial capacity. Once your workspace is assigned to Fabric, choose an online destination:
The following list contains the supported data destinations:
- Azure SQL databases
- Azure Data Explorer (Kusto)
- Azure Datalake Gen2 (preview)
- Fabric Lakehouse Tables
- Fabric Lakehouse Files (preview)
- Fabric Warehouse
- Fabric KQL database
- Fabric SQL database
- SharePoint Files
To get more information please check this:
https://learn.microsoft.com/en-us/power-bi/transform-model/export-query-results
If this solved your issue, please mark it as the accepted solution. ✅
Thanks anilelmastasi
My Workspace shows as Fabric Trial Workspace
Not sure why. Licese Info on some other workspaces shows as F64 Capacity.
Is Facric Trial good enough to use the Export Query Results feature?
Thanks,w
Hi tecumseh ,
Yes a Fabric Trial Workspace is sufficient to use the Export Query Results feature, but it must be correctly enabled and tied to Fabric capacity. If you’re seeing “Unable to fetch data destinations,” it usually means either the preview feature isn’t turned on in Power BI Desktop or your workspace isn’t properly linked to Fabric capacity. Microsoft confirms that both Fabric trial and Fabric capacity workspaces can use this feature.
Verify Preview Feature is Enabled
In Power BI Desktop, go to File > Options and settings > Options > Preview Features.
Check Export Queries from Power Query. Restart Power BI Desktop if needed.Confirm Workspace Capacity
In the Power BI service, check that your workspace is assigned to Fabric Trial or F64 Capacity.
Trial capacity is valid, but if the workspace isn’t properly linked, destinations won’t appear.Check Destination Permissions
Ensure you have access rights to the chosen destination (e.g., Azure SQL DB, Fabric Lakehouse). If permissions are missing, the list may fail to load.
Hope this helps.
Chaithra E.
Hi tecumseh ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.Hi tecumseh ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
