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: ...
Vanchy_Liao
Advocate IV
Advocate IVHi 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.
jacccodezwartHelper I
Helper IVanchy_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
i guess the locale matters. you can check out the locale setting of PBIRS, Power BI Service and PBI Desktop.