Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created a dataflow working with Salesforce objects that was working greatly up until a recent update in the CRM that made some salesforce objects disappear from PBI online salesforce objects.
It is weird because these same SF objects appear when I use desktop power query.
I have a total of 700 available SF objects in dekstop, but only 500 in PBI online.
How can I display the missing SF objects in PBI online ?
Solved! Go to Solution.
This is the code that is generated by default.
let
Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]),
Account1 = Source{[Name="Account"]}[Data]
in
Account1
Change the API version to whatever your IT department recommends.
This is the code that is generated by default.
let
Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]),
Account1 = Source{[Name="Account"]}[Data]
in
Account1
Change the API version to whatever your IT department recommends.
Thanks, I tried directly with version 48 and it worked, all SF objects are now available !
Change the API version back to one that works for you (28 for example)
Power BI February 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
Thank you Ibendlin for your answer. It says in your link to change the API version in the advanced editor, but I cannot find it so far. Do you know where I can make the modification ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.