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.

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.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors