Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
ChemEnger
Advocate IV
Advocate IV

On-Prem execution not supported for entity... ...since it refers to another entity

I know there are lots of other questions (and some answers) in the forum for this question.

I have a Dataflow (Fabric capacity workspace) with multiple queries, most of which are created using the same function to append matching tables from two other Dataflows, with some further combination (merging) where needed.

I have one query that is not refreshing on the service, with the error that it is referring to another entity.  As far as I can see, there is no real difference between the query marked with the red cross compared to that with the green tick, but the latter works while the former fails.

The green-dot queries have Enable Load turned on, whilst the amber-dot (...Prep) is turned off (I have also tried with it turned on).

ChemEnger_1-1742829383908.png

I have tried following the success of @BugmanJ in Error: On-Prem execution not supported for entity" , including turning off Load for the red-cross query and using it only as a staging query - this also failed for the downstream query.

 

Edit:  I also tried splitting out the branching (the merge is to deal with some null records) into two separate queries, with Enable Load turned off, but this didn't work either:

ChemEnger_0-1742832957607.png

Edit 2: I also tried bringing the merge up to the front of the query. No joy 😢

ChemEnger_0-1742833684491.png

 

 

8 REPLIES 8
v-menakakota
Community Support
Community Support

Hi @ChemEnger ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you,
Menaka Kota.

Hi @ChemEnger ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Hi @ChemEnger ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

BugmanJ
Helper V
Helper V

HI @ChemEnger ,

To note i am not using fabric but I had to do the following:

1) Have first query which is the main query. Ensure any columns meet the requirements to be stored (it can not be ABC123). Do nothing else. I call this "Original Data Query"
2) Reference the above query. in a new query, I call this "Data Reference Query". Do nothing else to this query

3) Create 3rd Query, Reference the above "Data Reference Query" as the source. Now do what you want with it.

Do this for each, i found i had a lot but had them in folders and thus avoided the problem. Are you using the 3 query mechanism?

I did try this mechanism first of all, hence my linking to the thread.

 

I double-checked just now and am gettting exactly the same error.

 

Query 1 - Direct connection to another Dataflow, no steps other than navigation, all types correctly set

Query 2 - Directly references Query 1, no other steps, still correctly typed

Query 3 - Joins Query 2 to another query (simple, from a manually entered table, again correctly typed)

 

ChemEnger_0-1743579100090.png

 

I can get the model (Gen 1 Dataflow) to work if I turn off loading for (1) but I would like it to be an output in its own right, as well as feeding (3)

Ah, I struggled to reference another dataflow and got similar errors. You will also find problems if the first one is updating and the second one wants to reference it. In the end, I now have several large dataflows that all use alot of the same "starting" parts and then just changed the end bits to suit. 

Where Gen2 are any better I dont know yet.


v-menakakota
Community Support
Community Support

Hi @ChemEnger ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Have you tried creating a new Dataflow from scratch and copying over the queries? This can help identify and eliminate any potential corruption or configuration issues in the original Dataflow.
Can you provide the full error message you’re encountering in the Power BI Service? This will help in identifying the exact cause of the issue.





Hi,

 

I have now done a direct copy & paste of the entire set of the queries.  I still get the same error:

 

Error: On-Prem execution not supported for entity '[Query 3]' since it refers to another entity.. Param1 = [Query 3] Request ID: 3f48cb9e-8454-8b8d-de72-8eba4ddba04d.

 

It looks like I'll just have to make do with a disabled staging query, with an enabled direct reference as well as the joined query?

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082
Top Solution Authors