topic Re: PowerBI SQL Server Data Source Feature Request in Report Server

PowerBI SQL Server Data Source Feature Request

goforebroke — Wed, 10 Sep 2025 21:19:02 GMT

I would like the PowerBI SQL Server data source to support the parameter ApplicationIntent="ReadOnly"

We have dozens of SSRS reports connecting to our ReadOnly node in our AlwaysOn cluster.

We plan to move our reports to PowerBI server, but are running into problems because the SQL Server data source only supports the parameter MultiSubnetFailover=true, but not the parameter ApplicationIntent="ReadOnly".

Other data sources (OLEDB Driver, ODBC) support the parameter ApplicationIntent="ReadOnly" in PowerBI server, but do not support "Direct Query". ODBC and OLEDB only support import data with refresh schedules.
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

We need the delivered SQL Server data source in PowerBI to support the AlwaysOn parameter ApplicationIntent="ReadOnly" while performing a direct query to the data source.

Re: PowerBI SQL Server Data Source Feature Request

tayloramy — Wed, 10 Sep 2025 21:36:56 GMT

Hi @goforebroke,

This is a legitimate product gap. I recommend logging it on the official Ideas forum under the PBIRS or Power BI category so others can upvote. Include your scenario details: DirectQuery on PBIRS to AG listener, need to pass ApplicationIntent=ReadOnly. Link: Fabric Ideas.

If this helps, consider giving some Kudos. If I answered your question, please mark this as the solution.

Re: PowerBI SQL Server Data Source Feature Request

goforebroke — Thu, 11 Sep 2025 03:44:37 GMT

Hi @tayloramy

The feature request has been posted

DirectQuery on PBIRS to AG listener, need to pass ... - Microsoft Fabric Community

Re: PowerBI SQL Server Data Source Feature Request

tayloramy — Thu, 11 Sep 2025 04:09:03 GMT

Now people just need to vote on it