Forum Discussion
Responsive ResidentBI Report Cannot Refresh in Service Yet Refreshes within Desktop
Super UserHi 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!
Responsive ResidentThanks
In the Service under 'Edit Credentials' I have the following message "(admin has granted access, credentials are not required)."
Assuming this confirms non-privacy issue
v-lili6-msftCommunity Support
hi IamTDR
You may refer to these similar post:
https://community.powerbi.com/t5/Service/Invalid-connection-credentials-Refresh-issue/td-p/410882
https://community.powerbi.com/t5/Service/Invalid-connection-credentials/td-p/410024
Regards,
Lin
- IamTDR
Thanks for the links. I reviewed each one.
Today I seemed to solve my issue. What I did was download my report from Service and reviewed the datasource within Power BI Desktop. I reviewed Data Source Settings and 'cleared permissions'. I then fully refreshed the report within Desktop and then Published. Within Service, I am now able to refresh On-Demand and as Scheduled.
Perhaps this info will help someone else someday.
Tim