Data Refresh Error

[akhatri]

Hi all,

For the last week I have been getting the below error when trying to refresh data online.

When I refresh the data in the Desktop environment it all works perfect.

Please help....

Data source error:	DataSource.Error: <pii>invalid query locator</pii>. <pii>{error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record"}</pii>. ;invalid query locator. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Quote Line Item.
Cluster URI:	WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID:	c1519a60-3756-4854-833b-0c03b4c43336
Request ID:	d690ae28-6beb-4638-b844-16494e6078fe
Time:	2022-07-06 11:12:34Z

Thanks in advance

Atish

[akhatri · Accepted solution]

Found the issue, turns out one the steps in Power Query where I was appending one table to another was the reason it was throwing this error up. Very strange.

[vanessafvg]

If it is working in the deskop, would it however still be useful to go into power query and refresh all previews of the tables an check if there is an issue? 

[akhatri]

I ran a refresh in Desktop and it ran fine so im bit confused why its not refreshing online.

[vanessafvg]

not not a refresh in the visual pane, go into power query assuming this is an imported model, where you do the transformations and refresh the preview of all the tables.  

[akhatri]

I just tested and all tables are refreshing (Refresh Preview) fine in Power Query