cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to verify Data source credentials on service for Read only node

The IT team has instructed me to use the secondary node for my PowerBI reports and the node is set to Read-Only. This was previously set to read/write and I had created my report, uploaded it to the service and scheduled my refreshes. A few days back it was set to Read-Only and I am reporting off this by setting the 'Enable SQL Server Failover support' to true to get the Read-Only string in my connection     1.jpg.(I am not sure if this is the correct way to connect but this is what we could settle on given the time and workload)

Now when I upload the report on premise after the Read-Only setting, I am unable to verify Data Source credentials. The report is working fine on premise and is also updating on the previously set schedule, however, I am unable to change the refresh time as the scheduled refresh section is all greyed out.

 

1.jpg

 

1.jpg

 

Any reason why I am not able to verify it but the report is working all fine. How do I fix this?

Let me know if you need any additional information.

1 REPLY 1
GilbertQ
Super User
Super User

Hi there

I would suggest reading my blog post below and configuring your Power BI report in the following way to get it to work

https://www.fourmoo.com/2018/11/19/refreshing-data-in-power-bi-from-sql-server-read-only-or-secondar...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!