Forum Discussion
Helper IIISalesforce Refresh
Hi leahschneider,
It's a limitation currently, you can go through this article: https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh#when-scheduled-refresh-cant-be-used
- If data source can be connected using only OAuth (e.g. Facebook, Google Analytics, Salesforce, etc.), then cache refresh plan cannot be created. At the moment, RS does not support OAuth authentication for any data source whether it is for paginated, mobile or Power BI reports.
You can submit your feedback in Ideas forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Qiuyun Yu
Resolver IHi leahschneider ,
I am very interested if You were able to set up a scheduled refresh or have you found a workaround for this problem?. We are currently refreshing the dataset by saving data on the Excel file and setting Task Scheduler and PowerShell for Refresh and also Scheduled Refresh in Power BI RS, but this isn't an ideal solution because of the often prompts for Credentials.
Thank you in advance
Helper IIII have since moved totally off report server and am now in the cloud so I'm not sure if this works. What I did was add a random database object (usually a small table for speed reasons) to the sources and that would work.