Data Flow refreshing Failed

Question

HI ! I am getting this error while refreshing data flow -On-Prem execution not supported for entity 'e36ce49b-04b8-4ed8-8536-c38c0a45c6c7/aa6f50f7-38b9-4937-8ee1-3f2798756730/CurrencyER_2Y' since it refers to another entity.. RootActivityId = e6ab7fa5-ddbd-44d1-9dc5-deba19828d93.Param1 = e36ce49b-04b8-4ed8-8536-c38c0a45c6c7/aa6f50f7-38b9-4937-8ee1-3f2798756730/CurrencyER_2Y Request ID: 9c705d3f-02aa-981e-2fcd-b0578f4fd4ed.Here is my data flow codes --Table CurrencyER_2Ylet&nbsp;&nbsp;DateFrom&nbsp;=&nbsp;Text.End("0"&amp;Text.From(Date.Day(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.End("0"&amp;Text.From(Date.Month(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.From(Date.Year(DateTime.LocalNow())-2),&nbsp;&nbsp;DateTo&nbsp;=&nbsp;Text.End("0"&amp;Text.From(Date.Day(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.End("0"&amp;Text.From(Date.Month(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.From(Date.Year(DateTime.LocalNow())),&nbsp;&nbsp;Source&nbsp;=&nbsp;Web.Contents("https://www.mnb.hu/en/arfolyam-tablazat/",[RelativePath="?deviza=rbCurrencyAll&amp;devizaSelected=ZAR&amp;datefrom="&amp;DateFrom&amp;"&amp;datetill="&amp;DateTo&amp;"&amp;order=1"]),&nbsp;&nbsp;#"Extracted&nbsp;Table&nbsp;From&nbsp;Html"&nbsp;=&nbsp;Html.Table(Source,&nbsp;{{"Column1",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(1)"},&nbsp;{"Column2",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(2)"},&nbsp;{"Column3",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(3)"},&nbsp;{"Column4",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(4)"},&nbsp;{"Column5",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(5)"},&nbsp;{"Column6",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(6)"},&nbsp;{"Column7",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(7)"},&nbsp;{"Column8",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(8)"},&nbsp;{"Column9",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(9)"},&nbsp;{"Column10",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(10)"},&nbsp;{"Column11",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(11)"},&nbsp;{"Column12",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(12)"},&nbsp;{"Column13",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(13)"},&nbsp;{"Column14",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(14)"},&nbsp;{"Column15",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(15)"},&nbsp;{"Column16",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(16)"},&nbsp;{"Column17",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(17)"},&nbsp;{"Column18",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(18)"},&nbsp;{"Column19",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(19)"},&nbsp;{"Column20",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(20)"},&nbsp;{"Column21",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(21)"},&nbsp;{"Column22",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(22)"},&nbsp;{"Column23",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(23)"},&nbsp;{"Column24",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(24)"},&nbsp;{"Column25",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(25)"},&nbsp;{"Column26",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(26)"},&nbsp;{"Column27",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(27)"},&nbsp;{"Column28",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(28)"},&nbsp;{"Column29",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(29)"},&nbsp;{"Column30",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(30)"},&nbsp;{"Column31",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(31)"},&nbsp;{"Column32",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(32)"},&nbsp;{"Column33",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(33)"},&nbsp;{"Column34",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(34)"},&nbsp;{"Column35",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(35)"},&nbsp;{"Column36",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(36)"},&nbsp;{"Column37",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(37)"},&nbsp;{"Column38",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(38)"},&nbsp;{"Column39",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(39)"},&nbsp;{"Column40",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(40)"},&nbsp;{"Column41",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(41)"},&nbsp;{"Column42",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(42)"},&nbsp;{"Column43",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(43)"},&nbsp;{"Column44",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(44)"},&nbsp;{"Column45",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(45)"},&nbsp;{"Column46",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(46)"},&nbsp;{"Column47",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(47)"},&nbsp;{"Column48",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(48)"},&nbsp;{"Column49",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(49)"},&nbsp;{"Column50",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(50)"},&nbsp;{"Column51",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(51)"},&nbsp;{"Column52",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(52)"},&nbsp;{"Column53",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(53)"},&nbsp;{"Column54",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(54)"},&nbsp;{"Column55",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(55)"},&nbsp;{"Column56",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(56)"},&nbsp;{"Column57",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(57)"},&nbsp;{"Column58",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(58)"},&nbsp;{"Column59",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(59)"},&nbsp;{"Column60",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(60)"},&nbsp;{"Column61",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(61)"},&nbsp;{"Column62",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(62)"},&nbsp;{"Column63",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(63)"},&nbsp;{"Column64",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(64)"},&nbsp;{"Column65",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(65)"},&nbsp;{"Column66",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(66)"},&nbsp;{"Column67",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(67)"},&nbsp;{"Column68",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(68)"},&nbsp;{"Column69",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(69)"},&nbsp;{"Column70",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(70)"},&nbsp;{"Column71",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(71)"},&nbsp;{"Column72",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(72)"},&nbsp;{"Column73",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(73)"},&nbsp;{"Column74",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(74)"},&nbsp;{"Column75",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(75)"},&nbsp;{"Column76",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(76)"}},&nbsp;[RowSelector&nbsp;=&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR"]),&nbsp;&nbsp;#"Promoted&nbsp;Headers"&nbsp;=&nbsp;Table.PromoteHeaders(#"Extracted&nbsp;Table&nbsp;From&nbsp;Html",&nbsp;[PromoteAllScalars&nbsp;=&nbsp;true]),&nbsp;&nbsp;Table&nbsp; USD_Rateslet&nbsp;&nbsp;DateFrom&nbsp;=&nbsp;Text.End("0"&amp;Text.From(Date.Day(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.End("0"&amp;Text.From(Date.Month(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.From(Date.Year(DateTime.LocalNow())-2),&nbsp;&nbsp;DateTo&nbsp;=&nbsp;Text.End("0"&amp;Text.From(Date.Day(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.End("0"&amp;Text.From(Date.Month(DateTime.LocalNow())),2)&amp;"%2F"&amp;Text.From(Date.Year(DateTime.LocalNow())),&nbsp;&nbsp;Source&nbsp;=&nbsp;Web.Contents("https://www.mnb.hu/en/arfolyam-tablazat/",[RelativePath="?deviza=rbCurrencySelect&amp;devizaSelected=USD&amp;datefrom="&amp;DateFrom&amp;"&amp;datetill="&amp;DateTo&amp;"&amp;order=1"]),&nbsp;&nbsp;&nbsp; #"Extracted&nbsp;Table&nbsp;From&nbsp;Html"&nbsp;=&nbsp;Html.Table(Source,&nbsp;{{"Column1",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(1)"},&nbsp;{"Column2",&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR&nbsp;&gt;&nbsp;:nth-child(2)"}},&nbsp;[RowSelector&nbsp;=&nbsp;"TABLE.pricetable&nbsp;&gt;&nbsp;*&nbsp;&gt;&nbsp;TR"]),&nbsp;&nbsp;#"Promoted&nbsp;Headers"&nbsp;=&nbsp;Table.PromoteHeaders(#"Extracted&nbsp;Table&nbsp;From&nbsp;Html",&nbsp;[PromoteAllScalars&nbsp;=&nbsp;true]),&nbsp;&nbsp;#"Changed&nbsp;Type"&nbsp;=&nbsp;Table.TransformColumnTypes(#"Promoted&nbsp;Headers",&nbsp;{{"",&nbsp;type&nbsp;date},&nbsp;{"USD",&nbsp;type&nbsp;text}}),&nbsp;&nbsp;#"Removed&nbsp;Top&nbsp;Rows"&nbsp;=&nbsp;Table.Skip(#"Changed&nbsp;Type",&nbsp;2),&nbsp;&nbsp;#"Renamed&nbsp;Columns"&nbsp;=&nbsp;Table.RenameColumns(#"Removed&nbsp;Top&nbsp;Rows",&nbsp;{{"",&nbsp;"Date"}}),&nbsp;&nbsp;#"Changed&nbsp;Type1"&nbsp;=&nbsp;Table.TransformColumnTypes(#"Renamed&nbsp;Columns",&nbsp;{{"USD",&nbsp;type&nbsp;number}})in&nbsp;&nbsp;#"Changed&nbsp;Type1"When i disable the load of USD_Rates table in the dataflow . Refresh was successful. Can anybody please tell me why is this happening? and Both CurrencyER_2Y and USD_Rates table are needed to be refreshed everyday. So if i will disable the load of USD_Rates table then will it get refresh internally with every successful refreshing of the data flow.&nbsp;&nbsp;Thanks in advance .&nbsp;Note&nbsp; -&nbsp; I am using an on premise gateway to get the data of the first two tables.&nbsp;&nbsp;Here is the gateway settings. -&nbsp;

anonymous · Answer

Hi&nbsp;Amar-Agnihotri&nbsp;,
&nbsp;
This problem seems to be caused by inappropriate licenses.
Dataflows are supported for Power BI Pro, Premium Per User (PPU), and Power BI Premium users. Some features are only available with a Power BI Premium subscription or Premium Per User (PPU) license.&nbsp;
Such as:

Enhanced compute engine
Direct Query
Computed entities
Linked Entities
Incremental refresh

For more details, you can refer to:Premium features of dataflows&nbsp;
&nbsp;
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Data Flow refreshing Failed

1 Reply

Related content

Data Refresh Failed

Data refresh failing due to account refresh limit (Pro)

Data Refresh Errors

Random Refresh Fail

Failed Refresh