Day name disappears when uploading from desktop to web

[jjswin]

Hi! 

I have a calculated column that displays the day name and it's used in a heirarchy like this:

And when I preview in desktop it looks lovely:

But when it's uploaded to web, the day name disappears  (and when you click see records, the Day Name column is blank.)

I'm using an on-premises gateway to get the data from a SQL Server 2012 database.

Any idea why this happens? 

Thanks!

[Baskar · Accepted solution]

Hi,

1. Are you using same data for desktop and  services ?

     If no this is data issue.

Note : Calculate field doesn't make any problem.

for me its working fine .

Let me know the status.

[jjswin]

Hi Bakar,

Thanks for replying; I fixed it today - it was to do with having a SQL column using datepart AND a column with the same name created within Power BI Desktop. There IS a bug in there somewhere as, like I said, it works in desktop but not once it's uploaded to web.

Thanks for your reply though! Have a good day.