Showing results for 
Search instead for 
Did you mean: 
Not applicable

Power BI converts automatically blank value into 0 on the power bi services (DIRECT QUERY)

Hello Everyone,

I have a problem with the behavior of Power BI (Direct Query). I have blank values on my column (Interger Data Type) and for my visualization I need the blank values. On my power BI desktop it works very well. But when I publish the dashboard on the portal power bi services (premium), and my blank values are converted automatically into 0 and my curves changed and are "wrong". Why don't we have the similar behaviour between power BI desktop and power bi services ? Is there any parameters to change? I tried some dax queries but nothing works. I don't have this problem when I use Import Mode.

Thank you for your help.

Super User IV
Super User IV

@Anonymous , I doubt that should happen unless the database does it.


Try these. Clear cache, refresh, and check

Or republish, Clear cache, refresh, and check 


Do you have an example measure or column for which this can happen. Please share that

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Not applicable

Hello @amitchandak ,

Thank you for your answer. Yes I tried to clear cache, re publish and refresh etc but it doesn't work.

I need to represent history/forecast. So I will have Null values for forecast column if I have values for History and Null value for history if values for forecast. 

On desktop visualization I have:



and when I publish I have :



All my Null values are converted into 0. 

I use Direct QUery and Azure PostGresSQL...


Thank you so much.

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors