PowerBI SQL Server Data Source Feature Request

[goforebroke]

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.

[goforebroke]

Hi @tayloramy 

The feature request has been posted

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

[tayloramy]

Now people just need to vote on it

[tayloramy · Accepted solution]

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.