PBI Service Refresh issue "Rowset does not exist" but working fine in PBI Desktop.

[nmbl]

PBI Desktop is refreshing just fine with the Salesforce data and column do exist, once republished tried to refresh on the PBI service and getting the error "There was an error when processing the data in the dataset." related to "Rowset doesn't exist for particular feild". There are no headers promoted or rename of columns, there is a direct connection with Salesforce production data.

[v-yingjl]

Hi @nmbl ,

Could not reproduce it in my side. You can try to publish the report to a new workspace and set the refresh for the dataset to check it again.

In addition, the data type of columns may cause this issue, you can also check the data type of the column field.

Best Regards,
Community Support Team _ Yingjie Li

[nmbl]

Thank you all for the response and ideas. looks like it got fixed its own not sure how but seems l;ike an issue with the connector.