cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wokroll
Frequent Visitor

Showing null instead of real value

Hi everybody.
Can you please help with my issue? I am completely stuck. Searching in the Internet didn`t give even any ideas. 

I am using CData connector to download data from Freshdesk to Power BI.
And I see very strange behaviour of Power BI. It shows me null values if I list all the rows, but if I filter to only 1 ID, it shows me real value. In any other cases(in diagrams, tables) always blank. I am talking about GroupIdsAggregate column.

wokroll_0-1630494416899.jpeg

Picture 1. Showing null in Power Query, same in Power BI

 

wokroll_1-1630494503440.jpeg

Picture 2. Wow, showing data

 

I have a thought that it may be encoding, but if filtered to one row - it shows. 

I am frustrated a lot. Thanks for any help. I don`t think that problem is with connector, because data is here, just isn`t showing.

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @wokroll 

 

Is your desktop version up to date? Download Microsoft Power BI Desktop from Official Microsoft Download Center

What are the data types of these columns in your source data? Probably because power query doesn't support this data type, the conversion is not successful, so it can't be displayed. When there is only one record, it will automatically convert it into a string.

 

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and feel free to ask me.


Best Regards,

Community Support Team _ Janey

View solution in original post

6 REPLIES 6
Juventus
New Member

Hi @wokroll ,

 

Can you look into below steps once.

  1. Remove all source files, except for the problematic one(s);

  2. Load up your Power Query script and navigate to step 1 and

  3. Enumerate through each step until you see the values disappear.

 

This will tell you which step fails. 

 

Regards,

Rakesh Js

 

v-janeyg-msft
Community Support
Community Support

Hi, @wokroll 

 

Is your desktop version up to date? Download Microsoft Power BI Desktop from Official Microsoft Download Center

What are the data types of these columns in your source data? Probably because power query doesn't support this data type, the conversion is not successful, so it can't be displayed. When there is only one record, it will automatically convert it into a string.

 

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and feel free to ask me.


Best Regards,

Community Support Team _ Janey

View solution in original post

It seems you are right. Maybe issue is because of API structure , if I query only 1 id, API returns me values. If I query whole list, it doesn`t return. I can`t understand how it refers to Power BI preview table, but anyway I found another way to circumvent this issue. That you guys for the anwsers.

mussaenda
Resident Rockstar
Resident Rockstar

Hi @wokroll ,

 

try refreshing your preview of dataset.

If you hide the null values, what are showing?

Thanks for the answer. I have only 60 rows, and they all shows blank in preview and in power bi table view. 
If I try to filter - I can see only blank values. Though they appear null in preview, if I filter to any ID it will show me blank string ("") or real value(some number). No duplicates or similar rows, I know it.
The row on first screenshot coloured grey has the same ID as on the second screenshot. So its the same data, same row. But it shows different values.

mahoneypat
Super User
Super User

The query editor shows a preview/subset of your data.  When you filter on the ID, you are previewing different rows (that have data).  Do you need the rows with null?  If not, you could filter to where that column <> null.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors