Error while trying to connect Power BI desktop to Data warehouse on Microsoft Fabric platform

[arinyc]

I developed a data warehouse on the Microsoft Fabric platform, which is intended to serve as a data source for Power BI reporting.

After I created a data warehouse (DWH) and loaded data into it, I attempted to retrieve data from the DWH to Power BI Desktop using the Warehouses connection in OneLakeHub (I utilized "connect to SQL endpoint" for the connection). This is the error that occurred:

Does anyone know what the cause of the issue is?

Thanks!

[Anonymous]

Hi @arinyc ,

Please try:

1.Navigate to your workspace, select the Warehouse, and select More options.

2.Select Copy SQL connection string to copy the connection string to your clipboard.

3.Paste the connection string copied from the previous section of this article into the Server name box. 

You can refer to the following documents that may be helpful to you: 

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

Create reports - Microsoft Fabric | Microsoft Learn

Connect to the Data Warehouse with Power BI - Microsoft Intune | Microsoft Learn

Best Regards,

Neeko Tang

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