Forum Discussion

FrisoW's avatar
FrisoW
Helper I
6 years ago
Solved

Empty columns

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

Need Help
  • rajulshah's avatar
    rajulshah
    6 years ago

    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?

5 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    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's avatar
      FrisoW
      Helper I
      6 years ago

      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's avatar
        rajulshah
        Resident Rockstar
        6 years ago

        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?