Forum Discussion
Helper IRefresh error, only on Onpremise Power BI Report server. Not on Desktop and not on PowerBI service
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.
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.
jacccodezwartVanchy_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.