Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jjswin
Regular Visitor

Day name disappears when uploading from desktop to web

Hi! 

 

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

 

Screen Shot 2016-11-19 at 01.10.59.png

 

And when I preview in desktop it looks lovely:

 

Screen Shot 2016-11-19 at 01.11.02.png

 

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

 

Screen Shot 2016-11-19 at 01.11.22.png

 

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

 

Any idea why this happens? 

 

Thanks!

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

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.

 

View solution in original post

2 REPLIES 2
Baskar
Resident Rockstar
Resident Rockstar

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.

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors