Forum Discussion
Responsive ResidentBI Report Cannot Refresh in Service Yet Refreshes within Desktop
Anyone experience this issue?
I can refresh this report within Power BI Desktop but once I publish this report to Service, it always fails during my nightly refresh.
I even tried to delete this report from Service and publish a fresh copy.
I have over 100 reports in Service and this is the only report having this issue. All reports pull data from the datawarehouse. Not sure why credentials are a problem for this one report.
Thoughts
Thanks in Advance
7 Replies
- collinq
Super User
Hi IamTDR ,
I would check each datasource in the report and make sure that each one is correct. I would also check to confirm that the "Privacy Level" in desktop is identical to the published version.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
IamTDRAnother interesting point, is that this same report refreshed without issue for the past two months. The issue just started happening this week. I haven't made any changes either.
- IamTDR
BTW, where or how would I check "Privacy Levels"?
- collinq
Hi IamTDR ,
In Desktop, look at Data Source Settings and select the Data Source and then select Privacy Level. In the service, go to the Dataset - Schedule Refresh - Data Source Credentials - Edit Credentials - Privacy Level
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
