Apply Query Changes error - for queries deleted from the model

[Anonymous]

Hi There,

I am getting following error on loading the OData Queries.

1. FactSalesLedger is actually disabled for Load

2. FactPOSTransaction is also disabled for load

3. FactWastage is a deleted query

More Info

1. FactPOSTransaction is disabled as it has large data and I don't want to enable it just yet. 

2. There is a separate table of measures which are refering to the queries disabled for load.

The fact tables have date field whose data type was changed in the Power Query, I have already disabled those steps with a view to change data type in Power BI Desktop once dat is loaded.

Any ideas on the cause and solution will be highly appreciated.

Thanks in advance 

Devinder

[v-jiascu-msft]

@Anonymous

Hi Devinder,

Maybe there are too many changes that applied at one time. Maybe you could try to change one query a time.

Best Regards!

Dale

[Anonymous · Accepted solution]

Hi Dale @v-jiascu-msft and Vanessa @vanessafvg,

Thanks for your replies. The issue was caused by version mismatch in one of OData Source. Once that was addressed, it was fine after that.

Thanks again for your help.

Regards

Devsarin

[vanessafvg]

@Anonymous there must be some dependency

can you post your m code for factitemledger?

[Anonymous]

Hi Vanessafvg,

Here is the code

let
Source = OData.Feed("https://Domain.ddns.net:7048/NAVLIVEPowerBI/OData/Company('WRG')"),
FactItemLedger1 = Source[FactItemLedger]
in
FactItemLedger1

Regards

Dev