R package works offline but not online

[Alex1602]

Hi guys,

I`m having problems with a visualization which I have created with R. It perfectly works on my power bi desktop account , but when I want to see it at app.powerbi.de, I get an Script Runtime Error.

In particular, it is because the function make_datetime from R package lubridate is not found.

I would be very happy, if you could help me!

[Alex1602 · Accepted solution]

Hi all,

No, there are no column names with unusual letters.

But I managed to get around this problem.

I used some other functions of lubridate.

Instead of make_date(), I used floor_date() to truncate date seconds. The problem then was, that it threw an error again, saying that a timezone had to be explicitly specified. Luckily lubridate also has a function for that: with_tz(). So my code for truncating the seconds became:

 lubridate::with_tz(lubridate::floor_date(TimeColumn, unit= "minute")), tzone = "GMT")

...Aaand it works 🙂

[v-haibl-msft]

@Alex1602

Please check your table column name to see if there are non-English term. If exists, please rename to an English term and republish to see the result.

Best Regards,
Herbert