Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Salesforce objects disappearing from PBI Online

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 ?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

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.

Anonymous
Not applicable

Thanks, I tried directly with version 48 and it worked, all SF objects are now available !

 

lbendlin
Super User
Super User

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

 

 

Anonymous
Not applicable

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 ?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors