cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Webs
Regular Visitor

Null Value columns not diplaying in power bi table - Can'r display the visual

Hi There,

 

I have been experiencing problems with the pwer bi graphics. I am connected to an cube (SSAS), and trying to visualize the data. When selecting certain columns of a table that has nulls, I get the following error "Can't display the visual". So I understand I may need to filter the query. When I use is or is not I still get the error. However if I use contains or starts with (since  in this case all data begins with the same text) it seems to be working. Is there something I am missing?

 

Thanks DP

3 REPLIES 3
Microsoft v-ljerr-msft
Microsoft

Re: Null Value columns not diplaying in power bi table - Can'r display the visual

Hi @Webs,

 

I have tested it on my side, I can show the column that has nulls on Table visual without that error.

 

Could you click "see details" on the error to see the detail error message and post it here?

e1.PNG

 In addition, could you post your table structure with some sample data which can reproduce this issue in this case? It's better to share a sample pbix file.Smiley Happy

 

Regards

Webs
Regular Visitor

Re: Null Value columns not diplaying in power bi table - Can'r display the visual

Hi,

 

Thanks for your reply. I had a few different errors (Last being the attached photo, which I will address, as it refers to memory). If the problem persists, I will find out if I could post the table structure as it contains sensitive info :(.

 

Much appreciated.

 

Regards,

Webs

 

Capture.PNG

Webs
Regular Visitor

Re: Null Value columns not diplaying in power bi table - Can'r display the visual

Hi,

 

This is the error i get. I am selecting columns from the same table, when I select CSA I get an error. Now if I filter the column and search for all values except for null, a dataset is returned.

 

If I import the data, instead of connecting live, it works with nulls.

 

Not sure what is going on, will increase memory and take it from there

 

 

Capture2.png

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors