Forum Discussion
Helper IUnable to connect Fabric Lakehouse using SQL Endpoint in MS Report Server
Hi, ssesham
Thank you very much for your reply. I have found another solution for you. You can consider the following two solutions:
First, you can use your Azure SQL Server database directly instead of using Fabric hosted Azure SQL Server database.This way you can authenticate with Database User in Report Server and then view your reports normally.If you don't want to connect directly to your Azure SQL Server database, you have the following option:
You can make custom authentication extensions to implement authentication to Azure SQL Server database that has Fabric hosting.
For documentation on custom identity extensions, you can refer to this link below:If you are not familiar with custom identity extensions, you can refer to the examples provided by Microsoft:
Reporting-Services/CustomSecuritySample at master · microsoft/Reporting-Services · GitHub
The second method you need to have an in-depth understanding of programming and then practice it.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThanks Li for the reply.
1) Query Issue: Report is running fine in report builder (which is in my local machine), issue is happening when i uploaded this report in report server (on-prem).
2) Connectivity Issue: I am able to connect the source Dataset (SQL EndPoint in Fabric) from my SSMS and also from other tools like (Power bi Report builder, Power Bi Desktop).
So I am not very much sure, whether I can connect Az SQL DB in Fabric from my Report server or not?
Hi, ssesham
Are you connecting to Lake house in Power BI Report Builder as shown in the following image:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.