Forum Discussion
Re-publishing Report does not update Application Intent
Hi mcho ,
You can use the following sql query to determine if the multi-subtnet failover works.
SELECT DATABASEPROPERTYEX(DB_NAME(), ‘Updateability’) AS Access; SELECT req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time, s.host_name, s.program_name, s.login_name FROM sys.dm_exec_requests req INNER JOIN sys.dm_exec_sessions s ON req.session_id = s.session_id WHERE s.program_name = ‘Mashup Engine’;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for reply.
I am pretty much doing roughly the same thing.
I have the multi-subtnet failover set but it doesnt replicate to the server after publishing.
Infact the refreshing from the PowerBI Desktop application works fine and i'm able to submit changes.
Also changing between the active and read only node also works. The connection string will reflect the server address change but NOT append the Application=ReadOnly setting to the connection string.
mcho wrote:
The connection string will reflect the server address change but NOT append the Application=ReadOnly setting to the connection string.
How can you tell? Are you getting told this by your DBA's?
The actual connection string will be built dynamically at run time, I don't believe you will see the "Application Intent" setting anywhere in the client side. Unfortunately I don't have an environment where I can check this for you. But if you are sure this is not working it's probably best to raise an official support ticket with Microsoft since the data providers in Power BI do not provide any way to edit the connection string directly so I don't believe there is any work around if this is not working correctly.
So I have enough access to see the data sources on the PowerBI Report Server side.
Based on my SSRS reports this is what i'm expecting to see.
But no matter what i upload i get the following.
As you noted you cannot directly edit the connection string in PowerBI "reports" hence it's grayed out. I can get the server address to change as already mentioned but it won't reflect the application intent. I do notice that the string is arranged differently. i.e. server;catalogue vs data source = server; initial catalogue = RSSQLDB_NSW; extra settings.
That said i'll defiantely have the call lodged i was just hoping someone may have come across this issue.