Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Apply Query Changes error - for queries deleted from the model

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    Anonymous there must be some dependency

     

    can you post your m code for factitemledger?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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