Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Day Name and Month Name missing when publishing to web app


i´ve created a Tile to show sales by day of the wook and another by Month.

i´ve created DayName and Month Name colums from "Date" Column using PI Desktop (Add Column>Date>Day>Name of Day)


It works well whent using it in Desktop but when i publish the report to the PI Web App the data of those columns is missing.

Other columns like "Month" or "DayOfWeek" work ok.


I´ve tried changing the language configuration from Spanish to English in Web app and the collation of the report in Desktop but not result.


Does anyone have experienced a similar issue? Any recomendation?


Thanks in advance and Regards,




Captura de pantalla 2016-09-01 a las 13.49.23.pngCaptura de pantalla 2016-09-01 a las 13.44.05.png




I have tested on my site, it works all fine for me. Could you share the pbix which can reproduce this issue with me? You can upload it to onedrive or dropbox and send me the link in private message. Do mask sensitive data before uploading.



Hi @v-ljerr-msft

Thanks for your time.


I can´t give you access to the source database so  I was preparing a test pbix to send you but I´ve realized that the problem appears when the data is updated using a Gateway. 


I´m trying to do more test in order to understand whats happening.


i´ll keep you updated





Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors