Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Criptop
Advocate I
Advocate I

Power BI hung on applying filter to a table

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. 

1 ACCEPTED SOLUTION
Criptop
Advocate I
Advocate I

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

View solution in original post

5 REPLIES 5
Criptop
Advocate I
Advocate I

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
Super User
Super User

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?

@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
Super User
Super User

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?

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.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors