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!
Salesforce connection refresh from gateway with other sources configured
Hi there, I'm updating a report that currently has multiple sources, such as on-prem files, odbc connectors, and some other items. This report is currently published to a gateway, and is scheduled to refresh from that gateway multiple times a day. I'm adding in Salesforce reporting, using the PowerBI default Salesforce connector. It works great locally, I can refresh and all, but when publishing out to the server I get message "Salesforce cannot be added to gateway". I've read numerous posts on this forum about how to have both web connectors & gateway connections, but don't quite get it. Is this possible? Can I keep my other sources refreshing, while also having a daily refresh from Salesforce? Thanks!!
Automatic Scheduled Refresh of PBI report published on Report Server
Hi, I am struggling to set automatic scheduled refresh for a PBI report published on PBI Report Server. It is a report combining datasources from Excel and live connection to a report in Salesforce. Is there any way how to set automatic scheduled refresh of the report? Thank you for any advice Best Regards jitkarobe
