Showing results for 
Search instead for 
Did you mean: 

OData queries with "Enable load: On" gets greyed out

Hi there! Robot Very Happy


I have been working on a couple of data models where my thoughts were to build comprehensive "master models" and disable unused queryes based on the needs of derived reports. 


Unfourtunately i have noticed that my queries (while working fine and loading on refresh) gets greyd out and looses the tick-mark in "Enable load" in the query editor - see below.

If i try to re-enable the query, i get the warning about possible data-loss (as if i was disabling the load) and nothing more happens - the query is stuck in this state.




My datasource for the affected queries is OData and the feed is concatenated text and text-parametres.

    Source = OData.Feed(ODataFeed &":"& Port & "/" & Instance & "/OData", null, [Implementation="2.0"]),
    Employee_BI_table1 = Source{[Name="Employee_BI",Signature="table"]}[Data]


The tables have all been added to the model by "add as new query" from a simple source query

The source query has "Enable load" disabled






    Source = OData.Feed(ODataFeed &":"& Port & "/" & Instance & "/OData", null, [Implementation="2.0"])


Now all of a sudden Power BI decided to "comply" with the bugged queries (Seeing them as disabled), resulting in all my tables being lost and my report crippled.


Any ideas on how to fix this?


Best regards


Status: Delivered

Update: Managed to unzip the .pbix and edit the DataMashup file. I changed "LoadToReportDisabled" from Value="l1" to Value="l0" on affected queries. 


This seems to solve the immediate problem, but does not explain why the queries get disabled initially and cant be coltrolled from the query editor.


Hi @NielsRH


I would suggest you create a support ticket to let engineers look into the issue on your side. 


Support Ticket.gif


Best Regards,
Qiuyun Yu 

Status changed to: Delivered
Idea Statuses