Forum Discussion
Data Refresh Error
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
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.
5 Replies
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?
I ran a refresh in Desktop and it ran fine so im bit confused why its not refreshing online.
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.
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.
