Semantic Model refresh not working

[JavierH]

I setup a semantic model a few months ago that would look into a specific folder in sharepoint and pull all the files within that folder, then run a transformation based on a set queries.

The workflow worked without issues for months and started breaking today.

Apparently, the main issue is that the query is not finding something (my guess is the shett called "load_hedge_forecast_crosstab" in the excel file).

When I open the transform layer in PowerBi I don't get any errors on my query,  but the error appears when I try to publish it. I deleted the last few files (assuming it was human error), but the query still doesn't work.

I hope someone can help me troubleshoot this. Thank you for your help!

The complete error reads:

Data source error:

[ValidateMarkupTags][ccon]Expression.Error: The key didn't match any rows in the table.. Key = [ccon][Item = "load_hedge_forecast_crosstab", Kind = "Sheet"][/ccon]. Table = [ccon]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.Mashup.Engine1.Runtime.BufferedListValue.BufferedValueReference.get_Value()#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(ListValue columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FromRowsFunctionValue.TypedInvoke(ListValue rows, Value columns)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record"[/ccon]. [/ccon];[ccon]The key didn't match any rows in the table.[/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Daily Snapshot.

[Anonymous]

Hi @JavierH ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

Best regards.
Community Support Team_Caitlyn

[JavierH]

Thank you @Anonymous , 

Do you have any idea of how long this would take? This is an important workflow for my organization and need to assess next steps. 

I appreciate your support.