Error Code: 104100 - MashupException.Error: Expression.Error: Failed to insert a table

[AndersASorensen]

Hi,

I have created a function that retrieves the max date in a data source. I would then like to filter another table with that max date as a filter. I works perfectly in Power Query...

However, when trying to publish it to a lakehouse I get an error (see below). Can someone explain why it would work in the editor, but not when I try to run/publish the dataflow?

Regards,

Anders

[StrategicSavvy]

Hi, 

It seems like Dataflow automatically convert type Record to Table after saving dataflow. You can check and probaly your MaxDate (query) will be saved and MaxDate (table). It causes a problem.

I tried same way as you did and refresh failed with same Error code.

Maybe somebody can suggest something more efficient but I would suggest solve it this way.

1. Convert your MaxDate to table, make sure Column1 has Date type

2. Sort your Sales table by date ascending

3. Merge your Sales table with MaxDate using LeftJoin type

3. Expand Column1

4. You will see your MaxDate right to date where it shoud start filtering

5. Use Fill down on Column1 - it will propagate same values down to the column

6. Filter out nulls in Column1 and delete column1

Now Dataflow completed. Be aware , this is leveraging computed entities in Dataflow so you will need  Premium per User/ Premium capacity. 

If you dont have it you can nest MaxDate inside Sales power query definition. 

I am looking forward to seeing more efficient ways!

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: www.linkedin.com/in/lukasz-kozdron