R script in Power BI returns date as Microsoft.OleDb.Date

Question

I am trying to convert a table to Power BI using function Run R Scriptin Edit Query. The source of the table is a csv file with a date column of the format "2017-01-04" (yyyy-mm-dd) :

Using Get Data, Power BI displays the same date column as this:

And after opening Edit Query windowthe same date column looks like this:

However, when you try to run R sctript with the same data, the column consists only of the "values" of Microsoft.OleDb.Date as follows:

R script I run simply:

# 'dataset' holds the input data for this script
output <- head(dataset)

If I try to change the data type, an en error is returned:

, Google. ?

Answer 1

, .

Power BI :

:

• csv Edit Queries :

2. R script

3. , script .