Forum Discussion
column does not exist in the rowset
Hello to everyone,
i have this problem for a while and couldn't find a solution.
To elaborate, I'm working on the salesforce datasource.
I can import the data of account and lead objects and refresh them on a power bi desktop.
But when I want to publish it to the cloud service and update the data, I get the following error.
Data source error: The 'Language__c' column does not exist in the rowset. Table: Lead.
Cluster URI: WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 78b9a7fd-e223-436d-8156-60398eb65520
Request ID: f40d2d0c-19bc-dbe9-8350-4b2a2938fa5d
Time: 2021-03-16 06:53:50Z
I deleted the fields where I got errors, changed their names, updated the datasource on the navigation step in the power query, I created datasets with different names. However, none of them have been resolved.
Finally, we opened tickets to Microsoft and Salesforce.
Microsoft said the problem was related to Salesforce security settings and did not assume the problem, Salesforce said that the problem is caused by Microsoft because the update can be made in the Power BI desktop 🙂
We are in a big impasse right now.
Anyone have a different solution on this issue?
Hi,
did you manage to resolve this issue with Power BI and Salesforce? I'm facing something similiar, I was going to raise a ticket with Microsoft but it would be good to know if you managed to fix this.
Thanks.