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
Highlighted
Microsoft
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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors