Dataset refresh Failure error

[sachin_s]

Hi,

We are facing a scheduled refresh failure in our dataset.
Our Power BI Desktop connected directly to Salesforce a object as asource, after publishing to Power BI Service, we have initiated a schedule refresh to the dataset which consistently failed.

The support team reviewed our pbix file and mentioned that many  Replace Values steps  and merge steps, is causing the issue as it has to traverse this conditions in 4000 records.

They suggested doing these replacements in the salesforce object itself or in a database system before feeding it into Power BI. Unfortunately, having a dedicated database for manipulation wasn't feasible.

Would love to know If anyone has faced a similar issue and a workaround for a similar situation.
The error we encounter for refresh failure is  "IDB Command interface error"

[lbendlin]

I agree with the support team's assertion.  Do not do any transforms.  Load your Salesforce object as is into a dataflow or dataset (with incremental refresh if you must)  and then reference it in your reports.

Unfortunately, having a dedicated database for manipulation wasn't feasible.

you may want to reconsider.