readonly
1 Topic
PowerBI SQL Server Data Source Feature Request
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.Solved992Views0likes3Comments