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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

danextian

 

Hi,

 

I can’t reproduce your issue. Please check these things below to do a trouble shooting.

  1. Upgrade PBI to the latest version. (2.46.4732.721 64-bit (May 2017))
  2. Try to reduce the fields. Reference here: http://community.powerbi.com/t5/Desktop/Query-Salesforce-Data-Error-Query-too-complicated/m-p/61053/highlight/true#M25057
  3. Do “get data, merge queries” first, then do the other actions such as renaming columns etc.
  4. Try to use “Merger queries as New”.

  

Best Regards!

Dale