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.
Hi, ssesham
Thank you very much for your reply. Due to the limitations of Report Server. We can't call OAuth2 authentication directly in the Report Server portal and then access the contents of the Fabric. We can do this in two ways:
1. Try your data source to use a data source that is supported by Report, please note that you should choose a data source that can be accessed using Windows or database user authentication.
2. Create a new web page based on your website, publish this paginated report to Power BI Service, and then use Power BI embedded to embed this paginated report into your new web page.
During the embedding process, you can use service principal validation. Service principal authentication without requiring the user to sign in to Power BI Service.
Documentation related to paginated report embedding can be found at the following link:
Embed paginated reports in your Power BI embedded analytics application - Power BI | Microsoft Learn
Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn
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 IHi, 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.