Report error in Power BI Service

[admin_xlsior]

Hi guys,

What happened when in Power BI Desktop all the visual display are fine, but when Publish to Power BI Service, over there none of the visual works ?

Both are using the same data source which is Azure SQL, and what strange is the filter (slicers at the top) are working fine, only all the visual having that error.

I even try to download PBIX from this report, and open the downloaded one (with PBI desktop), and it is working fine. Publish again, then the error in Power BI Service persist.

Where to check and what could possibly gone wrong ? Btw I have other report that connect with the same data source (only different table), and working just fine. 

Thanks

[Anonymous · Accepted solution]

Hi @admin_xlsior ,

A similar issue has been submitted internally.

Internal ICM ID: 290662099.

If there is any news, I will update it here.

Best Regards,

Jay

[Nepal101]

Support | Microsoft Power BI

have the same issue found the Power BI service is only on read mode currently, we couldn't save or publish the report.

[blopez11]

At times, I have found the need to select the refresh visuals icon on the report

You may also try, if you haven't already, refreshing your dataset in the service, and also refreshing your browser

If these don't work, what does the error message say when you select "See details" for the visual?

[admin_xlsior]

Hi,

Well, actually did a couple of time already for the Refresh Visual button, with no fix. As well as refreshing dataset manually and refresh browser.

There is an error message in top bar saying like this :

As for the visual error on each of it has this ->

Still the weird thing is the slicers are working, means nothing wrong in the connection ->

also the other reports that use the same data source are working just fine.

May I know where to check if this happened in PBI Service ? somekind of a system log ?

Thanks

[admin_xlsior]

Hi, 

Anyone know what is this ? 

And how to handle this eventually ? or what next should I do to be more closer to the cause of the error.

This is from Developer tools in my browser.

Thanks

[admin_xlsior]

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