Forum Discussion
Salesforce 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
I 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.
Power BI Service uses the gateway to refresh SalesForce data and PBI Report Server doesn't have that possibility so we have to think of a solution via some other resource.
You leahschneider , are better off on the Service.
If anyone has a solution for scheduled data refresh or knows when can we expect it in PBI Report Server in the future, feel free to replay.