Card Visual working locally but not on Service when using Today()

[ElliotP]

Evening,

I have a bit of an unusual issue I've never encountered before. On one of my pages I'm using a card visual to show a value which is filtered to only show the value corresponding to Today().

Locally the value shows up. It consistently appears when refreshed locally as expected without trouble.

When I publish the report the values don't appear, when I update the report, the values don't seem to appear.

The locale of the pbix is set to English(United States) and I'm a little bit out of ideas why this isn't working.The issue occurs on the three card visuals on the Stock Management Daily Page.

I've attached the pbix below. To refresh the pbix you'll need some SQL credentials from me.

Shared Pbix One Drive Link: https://1drv.ms/u/s!At8Q-ZbRnAj8iA3c3-zcYXAj3jvd

[v-yulgu-msft]

Hi @ElliotP,

I published the .pbix file you shared with us, the card visuals all displayed values correctly, acted the same as in desktop locally.

Have you tried to republish the report for a test? Also, please try to directly uploading .pbix file on service site (Get data->Files->Local file) rather than clicking publish button. Remove the card visuals and recreate them, will issue persist?

Regards,

Yuliana Gu

[ElliotP]

I'll the the "Get Data" suggestion, I'm not sure what's going on. I'm having a similar issue across a few visuals. I'll let you know.

Sorry for the late response.

[v-yulgu-msft]

Hi @ElliotP,

Does this issue still exist?

Regards,

Yuliana Gu