Report error in Power BI Service

Hi guys,

I finally found the cause of the error and it is because in my table I put a Power Query language to filter some data based on other table.

So the behind story is like this :

1. I have one table for Item Master (lets called it : ITEM_MASTER)

2. I have 2nd table for Item Transactions (called : TableTransactions), and these 2 are connected with a unique key

3, In my 2nd table, I need to filter the data based on its related item found in Item Master but first I need to filter the Item Master with certain condition.

So upon searching how to do it, I found and using this approach / code :

let
    Source = Sql.Databases("abcd.database.windows.net"),
    AxDW = Source{[Name="AxDW"]}[Data],
    dbo_Transations = AxDW{[Schema="dbo",Item="TableTransactions"]}[Data],
    ItemList = Table.SelectRows(#"ITEM_MASTER", each [Category] = "Other" and [Item type] = "Item")[ROW_UNIQUEKEY],
    Filtered = Table.SelectRows(dbo_Transations,each List.Contains(ItemList,[Transactions_ItemNum_FK]))
in
    Filtered

As mentioned, in TableTransaction,  I need to filter first the items based on the ITEM_MASTER's list with field criteria of "Category='Other'" and "Item type='Item'"

Those 2 rows named : ItemList and Filtered served the result that I need, so far, and still is in Power BI Desktop, but somehow now in Power BI Service, it return error "There is an error when processing dataset"

Anyone can help me what's wrong with this two rows of Power Query ? 

If I delete this 2 rows, the error will be gone. Only of course the rows in TableTransactions will not filtered at the backend. Reason why I want to filter at the backend, is because I cannot just filtered Item Master in front because it will then produced TableTransactions rows with no ItemMaster relation, Blank which then I need to add more filter to exclude "Blank" everytime I'm showing this table (TableTransactions) in visual.

And I also cannot use JOIN (DAX Function) because it will then produced "Import Mode" while I really need to only have "Direct Query". Also cannot "Mixed mode".

And unfortunately, this error only happened with Direct Query.

Why I'm saying so far is fine, even in Power BI Service, is before I updates my report (PBIX) using the Dec 2022 version, which is a old version of August 2020, everything is displayed correctly, both in PBI Dekstop and in PBI Service.

Now as I update with the latest version, while still fine in Power BI Dekstop, published to PBI Service will throw that error.

Thanks