Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ruxandraalina
Helper I
Helper I

Connecting to Fabric Warehouse - integrated security error

Hello, 

 

I've been struggling with an error and hopefully someone can provide some guidance. 

I have a Gen2 dataflow that collects data from an ODATA feed. This dataflow is then used to populate a Fabric Warehouse. 

Then, I am using the SQL endpoint in Power BI Desktop in order to import the data from a view in the Warehouse. 

I was able to successfully set everything up, developed the report, even refreshed the dataset multiple times. 

 

However, out of a sudden, I get below error. I haven't changed anything in my dataflow/warehouse/dataset. 

 

ruxandraalina_0-1700053334201.png

Does anyone know what the error might represent? 

Thank you!

1 ACCEPTED SOLUTION
v-cboorla-msft
Community Support
Community Support

Hi @ruxandraalina 

 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing.

Here are some possible explanations for the error you are encountering.

  • Make sure that you have the latest version of Power BI Desktop installed.
  • Try to use a different authentication mode when connecting to the SQL server. By default, Power BI Desktop uses Windows authentication, which may not work for some SQL servers.
  • Please check the firewall rules for the SQL server and the Power BI service.

If the issue still persists, please let us know.

I hope this helps. Please do let us know if you have any questions.


View solution in original post

3 REPLIES 3
v-cboorla-msft
Community Support
Community Support

Hi @ruxandraalina 

 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing.

Here are some possible explanations for the error you are encountering.

  • Make sure that you have the latest version of Power BI Desktop installed.
  • Try to use a different authentication mode when connecting to the SQL server. By default, Power BI Desktop uses Windows authentication, which may not work for some SQL servers.
  • Please check the firewall rules for the SQL server and the Power BI service.

If the issue still persists, please let us know.

I hope this helps. Please do let us know if you have any questions.


Hi @v-cboorla-msft 

 

Thank you! I have updated the SQL Server authentication method under 'Manage connections and gateways' and set it to OAuth 2.0. I'm not sure what this actually means, but it is working now. 

Hi @ruxandraalina 

 

Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

 

Thanks

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.