Forum Discussion
jacccodezwart
Helper I
1 year agoRefresh 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: ...
- 1 year ago
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.
jacccodezwart
Helper I
1 year agoVanchy_Liao thanks for your suggestion to change the datetime format in Power Query.
Not only I needed to change the datetime format for my variable, but allso of all the columns which I check using my variable.
That seemed to solve the refresh on the Power BI on-premise report server.
Still remains the question why is this not needed on the Power BI Service (app.powerbi.com) and not needed in Power BI Desktop.
Vanchy_Liao
Advocate IV
1 year ago
i guess the locale matters. you can check out the locale setting of PBIRS, Power BI Service and PBI Desktop.