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

[Anonymous]

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.

[amitchandak]

@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

[Anonymous]

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.