Salesforce Report Problem with lastest Power BI Update
Hi, I'm having an issue importing 3 salesforce reports into Power BI. Here are a few things to note: - problem started after I did a Power BI update a couple of weeks ago - I've been using these 3 salesforce reports to generate a dashboard for the last year with no problems - the salesforce report is pulling the right data. Verified by downloading the data into an excel file - power bi seems to be bringing in the wrong data and am not sure why - I also get the following error when importing data for one of the 3 reports OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). Any ideas on what might be causing this problem? Thank you!
Report Builder Connection to OLE DB
Hello, I am able to connect to OLE DB on Power BI Desktop, however when trying to use Report Builder (OLE DB Data Sources are defined on the on-premise report server), I am receiving the following error The 'OraOLEDB.Oracle' provider is not registered on the local machine. I have tried to also install ODAC 32bit for Report builder but as my Windows version is 64bit, it did not work. Any ideas?
Connection to IBM SPSS Data Collection
Hi all, My I kindly ask you to advise, how to connect PBI to IBM SPSS Data collection (formally called Dimensions)? I have used OLE DB, but when I try to connect via IBM SPSS Data Collection DM-2, and pres "Next", my PBI crashes and automatically closes itself. Thanks a lot.
