The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am linking Salesforce to Power BI and am attempting to concatenate rows if they have duplicate 'HP Opportunity Id' but it is telling me "Expression.Error: The column 'HP Opportunity Id' of the table wasn't found.
Details:
HP Opportunity Id"
But my column is labeled 100% correct. Please let me know if you need more information
Hi @MarcelBeug were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:
After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:
There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
In step "GroupRows", you try to group the initial Source table, instead of the table from the previous step #"Sorted Rows".