I have been facing this issue for the past 1 year that when I connect Opportunity object from Salesforce it is throwing me this error. I contacted Salesforce and they told me that this error is coming from Power BI side and that their API version is 29. When I asked power BI they said they don't have work around for this. This is really annoying as everytime I had to extract the Opportunity object into a excel and connect it with power BI and hence it's useless even if auto refresh is enabled. Is there any work around to fix this ? Kindly help.
When I asked power BI they said they don't have work around for this.
If the Power BI Product Team have confirmed this is still a known limitation, and there is currently no workaround for it, I would suggest you add it as an idea on Power BI Ideas forum and vote it up to improve Power BI on this feature.