Forum Discussion

IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive Resident
6 years ago

BI 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 t...
General Comment
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  IamTDR 

You may refer to these similar post:

https://community.powerbi.com/t5/Power-Query/Invalid-connection-credentials-while-adding-data-sources/td-p/433743

https://community.powerbi.com/t5/Service/Invalid-connection-credentials-Refresh-issue/td-p/410882

https://community.powerbi.com/t5/Power-Query/Invalid-connection-credentials-while-changing-data-in-query/td-p/1186879

https://community.powerbi.com/t5/Service/Invalid-connection-credentials/td-p/410024

 

 

Regards,

Lin

IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive Resident
6 years ago

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