Power BI Report server change my date fields
Hi, guys, I have a problem with Power BI Report Server (PBIRS). I have a DATE column in my PBIX that is changed when it is refreshed in PBIRS. It is a DATE field, not calculated. Comes directly from my table in MySql. Working locally using Power BI Desktop for Report Server (PBIDRS), the dates look normal. Let's say that I refresh my PBIX and none of the dates in my column are greater than the time I am running it. If I publish the dashboard in Web Services, dates look normal, even if I refresh the dashboard. But, if I publish the dashboard in PBIRS, while it is not refreshed, the dates are normal, but when it is refreshed by schedule, the dates jump 5 hours ahead. If we were talking about a calculated refresh date, I know I will receive a UTC date. That is the server’s way. But why MY data? Is like I am using a sales amount and the server is modifying MY TABLE data adding a fixed amount to it. Any idea on why this is happening?
Different time in online report vs. desktop / last refresh time and created time
Hey there I think I watched almost every tutorial video to this topic but I'm obviously missing something. I have problem with the local time showing correctly in the online reports. In the desktop report every thing is fine and correct according to my data source sharepoint - but online all the times are 2 hours behind, despite to formatting them to local zone times. As for the formating of the columns e.g. the last data refreshing time in my desktop report: - new Query with custom column - used formula: DateTimeZone.LocalNow() - data type: Date/Time/Timezone I'd be verry thankful if anyone could tell me what I am doing wrong.
report refresh and timezone not updating
Hi, I am having a problem with daily reports being a 10 hours behind. I am in UTC+10 Syd Aust I date my reports with DAX (TODAY) and my reports do not display todays data until 10am UTC+10 Datasets and scheduled refreshes always work How do I get everything in the correct timezone? Thanks in advance 🙂
