Data source Error when connecting Opportunity object from Salesforce

Hi All,

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.