Forum Discussion
Helper IIIPaginated report - MFA authentication is a requireent
Hi arunbyc
Unfortunately, you can’t connect Report Builder directly to SQL Server if MFA is required.The workaround is pretty simple though:
Push your SQL data into a Power BI dataset through the gateway (that already takes care of MFA).
Point Report Builder at that dataset instead of the SQL server.
Add FromDate and ToDate as parameters in your report and use them to filter the data.
Publish the .rdl to a Premium/Fabric workspace, and from there you can run it online and export all 750k+ rows to Excel.
That way you sidestep the MFA roadblock and still get flexible, parameter‑driven reports with big exports.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Super UserHi arunbyc
Unfortunately, you can’t connect Report Builder directly to SQL Server if MFA is required.
The workaround is pretty simple though:
Push your SQL data into a Power BI dataset through the gateway (that already takes care of MFA).
Point Report Builder at that dataset instead of the SQL server.
Add FromDate and ToDate as parameters in your report and use them to filter the data.
Publish the .rdl to a Premium/Fabric workspace, and from there you can run it online and export all 750k+ rows to Excel.
That way you sidestep the MFA roadblock and still get flexible, parameter‑driven reports with big exports.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡