Power BI hung on applying filter to a table

[Criptop]

Hi all,

Had a good search on the forums but couldn't find a solution.

I have a simple table with a list of details of invoices and credits (data from a Power BI dataset), one of the columns being a Value column with positive values for invoices and negative values for credits. When there are no filters applied, the table shows everything. When a filter on the Value column is appled to show only items with a value above zero (i.e. invoices only), it lists only the invoices. However, if I apply a filter on the Value column to show only items with a value below zero (i.e credits only), Power BI hangs and never applies the filter.

I have used the performance analyzer and initially the negative value filter came up with an 'Other' processing time of 276207 ms, but now it's been hanging for about 1.5 hours and is still trying to apply the filter.  

Still quite new to Power BI and would really appreciate assitance on this issue. 

[Criptop · Accepted solution]

Hi All,

Just in case anyone is looking at this down the line, I ended up just recreating the report in a new PBIX file. Used the same measures, tables, visuals etc but it works fine and quickly applies the filters.

Thanks

[HotChilli]

OK, so nothing to concern us in terms of the visual or measures.  It seems to point to a network latency or firewall issue or model connection problem.   It's not something I have any particular expertise in.  Can you experiment by creating another pre-filtered dataset in the service and connecting to that?

[Criptop]

@HotChilli Sorry for delayed reply. Was on leave and have been tasked with other reports to create first. I'll try recreating the report and see if that solves the problem. Will update this thread when I can

[HotChilli]

Can you clarify this part "data from a Power BI dataset" ?  Is this referring to an imported model or are you connecting to a dataset hosted in the service?

--

Is it one table visual which draws data from several related data tables?

How many rows in the table?

Does the table visual contain any complex measures?

[Criptop]

Thank you for your message.

I am connected to a Power BI dataset which I have published to the Service. The Dataset uses DirectQuery.

It is one table visual that draws data from 2 related data tables

There are 68,000 rows in the visual table.

There are no complex measures in the table.