Forum Discussion

danextian's avatar
danextian
Super User
9 years ago

DataSource.Error: invalid query locator when expanding a column

Hi All,   I'm trying to expanding a column from two merged queries. Both queries are from two separate salesforce objects. The second one only has one column called Materials.  However, when I try ...
Need Help
danextian's avatar
danextian
Super User
9 years ago

It seesm that this is an issue with salesforce objects that PBI desktop cant properly handle. As shown on the screenshot below, the remove errors features doesn't work.

 

 

The error is still the same:

 

DataSource.Error: invalid query locator
Details:
    List
GCL's avatar
GCL
Frequent Visitor
8 years ago

Dear,

 

I had the same "invalid query locator" issue with Salesforce.com related data.

After selecting the following menu path "Power BI Desktop - Home - Edit queries - Advanced Editor", I changed the "source" parameters :

 

Situation before :

let
    Source = Salesforce.Data(),
    Opportunity1 = Source{[Name="Opportunity"]}[Data],
    #"Filtered Rows" = Table.SelectRows(Opportunity1, each [Dep_Code] = "PER")
in
    #"Filtered Rows"

 

Situation afterwards:

let
    Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true]),
    Opportunity1 = Source{[Name="Opportunity"]}[Data],
    #"Filtered Rows" = Table.SelectRows(Opportunity1, each ([Dep_Code] = "PER"))
in
    #"Filtered Rows"

 

That means:  the issue in my scenario has been solved by approaching the Salesforce data via my corporate salesforce account + applying correct source parameters.

 

Cheers!

Gaston

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This fixed it for me too, thanks

  • gsndeepak's avatar
    gsndeepak
    Regular Visitor
    7 years ago

    This method worked for me. Thanks for sharing!