Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm seeking advice on how to connect PowerBI to a data warehouse and utilize direct query mode. I've scoured the internet but haven't found any solutions. Can anyone provide guidance on this?
Solved! Go to Solution.
Hi @Mohith_ei ,
After my research, so far Warehouse only supports Import mode.
You can find the limitation here:
Power Query Warehouse (Beta) connector - Power Query | Microsoft Learn
Connect to the Data Warehouse with Power BI - Microsoft Intune | Microsoft Learn
And if you have a large amount of data, I would recommend a workaround with either using Pipeline Deployment in the Advanced Workspace or using Power BI Custom Connectors:
How to achive clickhouse connection with direct qu... - Microsoft Fabric Community
GitHub - belyaevvo/ClickHouseConnector: Power BI connector for ClickHouse
In addition, the connection to the data warehouse is still in the testing phase, I suggest that you can make your suggestions here, and maybe one day your suggestions will be accepted and you will be able to use the Direct Query mode to connect to the data warehouse!
idea
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mohith_ei ,
After my research, so far Warehouse only supports Import mode.
You can find the limitation here:
Power Query Warehouse (Beta) connector - Power Query | Microsoft Learn
Connect to the Data Warehouse with Power BI - Microsoft Intune | Microsoft Learn
And if you have a large amount of data, I would recommend a workaround with either using Pipeline Deployment in the Advanced Workspace or using Power BI Custom Connectors:
How to achive clickhouse connection with direct qu... - Microsoft Fabric Community
GitHub - belyaevvo/ClickHouseConnector: Power BI connector for ClickHouse
In addition, the connection to the data warehouse is still in the testing phase, I suggest that you can make your suggestions here, and maybe one day your suggestions will be accepted and you will be able to use the Direct Query mode to connect to the data warehouse!
idea
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |