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
sgeheeb
Helper III
Helper III

Data Flow (Gen1) Refresh fails

Hi,

 

I have a dimension table which is used in multiple data models, so I decided to move it to a data flow (for the ovious reasons).

In the Preview, everything looks finde, but the dataflow fails to refresh. When i download the .csv, the error message is empty (Only Activity-ID and Request-ID are provided).

 

The dataflow is located in a Pro Workspace and using PPU is not an option for this particular customer.

 

I suspect this has to do with the computed entities not being available for Pro workspaces.

 

The dataflow uses multiple tables, which are joinded, merged, etc..  However, only one table (the final result) has its "Load" activated. 

When I activate the "Load" for multiple tables, I get the "Bolt" Icon and the error message, stating that this won't fly in a Pro Workspace. 

In my current setup, only one table is loaded and both the bolt and the warning disappear. 

Can anyone confirm that the computet tables are still the issue, and the waning simply fails to display? Or could there be other reasons (which I might acutally be able to fix :))

 

Best,

Stephan

9 REPLIES 9
Streamline
Frequent Visitor

Any update?

We experience similar problems with refreshing Gen1 dataflows on Business Central Saas.

No, this seems to be the designed bahaviour. I am guessing that you are creating a computed entity (bolt icon) at some point, which requires a PPU license. My solution was to perform as many transformations as possible in the dataflow (without creating a computed entity) and take it from there in Power BI Desktop. Still not ideal, but better then nothing.

DoubleJ
Solution Supplier
Solution Supplier

hi, 

have you found a solution to this issue?

Unfortunately, no 😞

thanks for your quick reply.

Coldfish
Regular Visitor

Is it the source Oracle On premise ?

Hi @Coldfish , no, the data source is Business Central SaaS, so basically REST-APIs.

v-xiaoyan-msft
Community Support
Community Support

Hi @sgeheeb ,

 

Checking the refresh history might provide more insights. You can do this by navigating to the dataflow settings and reviewing the refresh history. This might help you identify specific steps or entities causing the failure.

If computed entities are essential for your dataflow, consider breaking down the dataflow into simpler steps or using Power Query in Power BI Desktop to perform complex transformations before loading the data into the dataflow. And please ensure that your dataflow is optimized for refresh.

This includes minimizing the number of transformations and ensuring that only necessary tables are loaded.

 

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

 

Best regards.
Community Support Team_Caitlyn

Hi,

thanks for the reply. As I said, the refresh history of the dataflow does not contain any information on the nature of the error. This is the content of the .csv:

Requested on,Name des Dataflows,Aktualisierungsstatus für Dataflow,Tabellenname,Partitionsname,Status aktualisieren,Startzeit,Endzeit,Dauer,Verarbeitete Zeilen,Verarbeitete Byte (KB),Max. Commit (KB),Prozessorzeit,Wartezeit,Compute-Engine,Fehler,
2024-10-07 11:10:50,Artikel,Fehler,Artikel,NV,Fehler,2024-10-07 11:10:50,2024-10-07 11:13:21,00:02:31.7530,NV,NV,NV,NV,NV,NV,Error:  Request ID: 76f9ec38-f294-d8a2-ecd8-fbb205f3c66e Activity ID: df72a89c-316c-4347-95c8-9f8ad465fb23

The computation of the dimension table is currently done in Power BI Desktop (In four different models). I am trying to move the creation of the table into a dataflow, so it only needs to be done once. This involves many stepts (mostly joining data from different source tables), which cannot be simplified any further.

 

Best,

Stephan

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
Top Kudoed Authors