It seems it is not possible to get the Note (ContentNote) data from Salesforce using Power BI.
We really need this functionality but it seems its not avaiable, the object is not in the list.
This is to return the Enhanced Notes in Salesforce from Lightning.
Does anyone have any workarounds or solution please?
Do you connect to Salesforce content pack in Power BI Service? If so, please use SalesForce object connector in Power BI Desktop instead to connect to your source and check if you can get Note.
Thank you for your response.
We are already using PowerBI Desktop using Salesforce Object Connector.
The "Note (ContentNote)" is not avaiable in the list - only the old legacy "Note" object, so this will not work for people using the enhanced version of Salesforce Notes.
It is also only avaiable in Salesforce Data Loader when selecting "Show all Salesforce objects"
Do you get expected result when you connect to Salesforce from Excel?
Can it be a security issue?
Have you checked the "Field level security" for the custom field? It should be visible for the profile of the user that is using Power BI/Excel.
You can try also deleting Power Query or Power BI cache and refresh preview.