Empty columns

[FrisoW]

Dear,

Since a couple of days I have an issue with data in a dashboard. When importing a table, all columns are filled in in the query view. When I apply & close, the data view has 3 empty columns. I'm completely stuck. PBI has been updated after having this problem without any luck. I had this before and out of frustration completely started over, but now days of work went in this project so this is not an option.

Data source is Microsoft CRM (crm4.dynamics.com)

Any suggestions?

Thanks

[rajulshah]

Hello @FrisoW,

It is very difficult to judge without going through the issue or logistics. Can you provide a sample file or the steps in the query editor for the table?

Maybe it would be little helpful to understand the issue.

[FrisoW]

Hi rajulshah,

I understand. I'll try elaborate because I won't be able to provide a sample file as the problem is limited to my project and this contains confidential data.

1. Get data, source is Dynamics CRM

2. Transform data

3. In query editor, I have 5 columns, with 0 blanks in all 5 columns and over 30000 rows

4. I close the query editor

5. I open the data view, 3 columns are completely empty

6. Also when I create a table in the report view, the columns are blank

I tried deleting the table and adding it again, but the same 3 columns remain empty.

No relatingships have been set yet.

This must be a bug?

[rajulshah · Accepted solution]

@FrisoW, Can I see the screenshot of the transformation steps?
OR 
You can do 1 thing : You can filter the blank values and then 'Close & Apply' the changes and see what you can see?

[FrisoW]

Transformation steps:

Source

Navigation

Removed Other Columns (all but those 5)

Filtered blanks in statuscode_display column, all 30000 values appeared.

Other columns remained empty, so filtered those as well. All values appeared.

This makes completely no sense but you managed to solve it anyway, thanks a lot!

[v-xuding-msft]

Hi @FrisoW ,

It seems that you have resolved the issue. Please accept the helpful answer as a solution. More people who have the same problem will benefit from the thread.