Forum Discussion
Helper IIIPaginated report - MFA authentication is a requireent
I am trying to design a Paginated report but am running into these issues:
I cannot connect Power BI Report Builder directly to our SQL Server data source, because our company requires multi-factor authentication (MFA) for SQL connections. I was told Report Builder currently does not support MFA authentication.
I’ve successfully used the Paginated Reports (Preview) feature in the Power BI Service for a few reports. But this does not seem to support FromDate and ToDate parametersm which I would need on some reports.
These reports contain more than 750,000 records and they require exporting to excel (so cant use regular export of Power BI reports with date slicers for the date range).
BTW, my Power BI datasets are connected to the SQL Server via an on-premises data gateway)
Given these, how do I create these paginated reports?
Thanks
Arun
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 💡
1 Reply
- DataVitalizer
Super User
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 💡