Forum Discussion
jacccodezwart
Helper I
Helper IRefresh error, only on Onpremise Power BI Report server. Not on Desktop and not on PowerBI service
Hi all, I have a problem I'm not able to solve myself. Hope you can help me. My dashboard uses two datasources. One is an OData source, the other is a direct database connection. SessionID: ...
Hi jacccodezwart ,
perhaps you can check the language settings for the PBIRS and Power BI Service.
Or you can change your data to string format and convert it into datetime format in Power Query.
I'm having the same issue here. Was there ever a solution identified?
jacccodezwartHelper I
Helper IHey Chris,
The solution was to check types of both my variables and columns that were used in a formula. The variable was of date-time format and the column which I used is a formula was of time-stamp-with-timezone format. For some reason, the server (or workstation) regional settings resulted in the fact that it would work on my laptop, but not on the report server.
By explicitly making all the field types the same, the problem was solved.