Forum Discussion
Helper VSaleforce Professional version refresh issue with PowerBi gateway
Community SupportHi gavin007
It's a typical question for years. After talking to both parties, salesforce and microsoft support; the only resolves I was able to find from microsoft were:
-use only one link per report, even if you are working with multiple tables, recreate the report fetching multiple tables at once (which is absurd for incremental reports).
-disable single sign on (which is another absurd idea because it might conflict company policy since this feature affects the entire salesforce users).
Luckily for me, we do not use SSO for my company and recreated the report fetching 3-4 tables all at once so that only one link is used this time rather than multiple; for me it is working however if it goes incremental, according to my previous experience, I can guarantee that issue will recur since no party guaranteed that the connector have been updated or so.
Helper VHi Dina,
I don't think my IT will allow SSO so that is out of question. but for the first point, what do you mean one link per reports? Currently, i have a single report need to retrieve different tables from SF to form part of the dataset. So it is kind of one refresh will fetch multiple tables from SF.
Also, you are saying it doesn't work for incremental refresh? I don't understand the logic of it, maybe more because of the above question.