Fabric Lakehouse with SSRS

[powerbiexpert22]

Can we connect SSRS reports to Fabric Lakehouse?

[NandanHegde]

Hey,

Unfortunately MFA is not enabled authentication for SSRS :

https://developercommunity.visualstudio.com/t/authenication-via-mfa-is-missing-from-ssrs/1100272

ANd Lakehouse doesnt support SQL auth, so you would have to create an accoutn with MFA disbaled and use SQL end point to access it from SSRS

[powerbiexpert22]

Hi @NandanHegde ,

Can you share the process for create an account with MFA disbaled and use SQL end point to access it from SSRS?

[collinq]

Hi @powerbiexpert22 ,

This article explains how to do this:

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

[powerbiexpert22]

Hi @collinq ,

the link you have shared is for connecting lakehouse with sql server , i need the details on how I can connect SSRS with lakehouse