Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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?
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.
Regards
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |