Forum Discussion

jisuk_kate's avatar
jisuk_kate
Advocate I
2 years ago

With the below message I can not refresh it.

 

With the below message I can not refresh it.

Even until yesterday, I could refresh this on persnonal gateway accordingly.

 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ADO.NET: R script error.\r\nWarning message:\r\npackage 'openxlsx' was built under R version 4.1.3 \r\n\r\nAttaching package: 'dplyr'\r\n\r\nThe following objects are masked from 'package:stats':\r\n\r\n filter, lag\r\n\r\nThe following objects are masked from 'package:base':\r\n\r\n intersect, setdiff, setequal, union\r\n\r\nWarning message:\r\npackage 'dplyr' was built under R version 4.1.3 \r\nLoading required package: DBI\r\nWarning message:\r\npackage 'RPostgreSQL' was built under R version 4.1.3 \r\n\r\nAttaching package: 'data.table'\r\n\r\nThe following objects are masked from 'package:dplyr':\r\n\r\n between, first, last\r\n\r\nWarning message:\r\npackage 'data.table' was built under R version 4.1.3 \r\n\r\nAttaching package: 'lubridate'\r\n\r\nThe following objects are masked from 'package:data.table':\r\n\r\n hour, isoweek, mday, minute, month, quarter, second, wday, week,\r\n yday, year\r\n\r\nThe following objects are masked from 'package:base':\r\n\r\n date, intersect, setdiff, union\r\n\r\nWarning message:\r\npackage 'lubridate' was built under R version 4.1.3 \r\nWarning message:\r\npackage 'odbc' was built under R version 4.1.3 \r\nWarning message:\r\npackage 'stringr' was built under R version 4.1.3 \r\n\r\nAttaching package: 'reshape2'\r\n\r\nThe following objects are masked from 'package:data.table':\r\n\r\n dcast, melt\r\n\r\nWarning message:\r\npackage 'reshape2' was built under R version 4.1.3 \r\nError in dim(ordered) <- ns : \r\n dims [product 1] do not match the length of object [0]\r\nCalls: dcast -> cast\r\nExecution halted\r\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"R"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"R"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.ExceptionType","detail":{"type":1,"value":"Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"R script error.\r\nWarning message:\r\npackage 'openxlsx' was built under R version 4.1.3 \r\n\r\nAttaching package: 'dplyr'\r\n\r\nThe following objects are masked from 'package:stats':\r\n\r\n filter, lag\r\n\r\nThe following objects are masked from 'package:base':\r\n\r\n intersect, setdiff, setequal, union\r\n\r\nWarning message:\r\npackage 'dplyr' was built under R version 4.1.3 \r\nLoading required package: DBI\r\nWarning message:\r\npackage 'RPostgreSQL' was built under R version 4.1.3 \r\n\r\nAttaching package: 'data.table'\r\n\r\nThe following objects are masked from 'package:dplyr':\r\n\r\n between, first, last\r\n\r\nWarning message:\r\npackage 'data.table' was built under R version 4.1.3 \r\n\r\nAttaching package: 'lubridate'\r\n\r\nThe following objects are masked from 'package:data.table':\r\n\r\n hour, isoweek, mday, minute, month, quarter, second, wday, week,\r\n yday, year\r\n\r\nThe following objects are masked from 'package:base':\r\n\r\n date, intersect, setdiff, union\r\n\r\nWarning message:\r\npackage 'lubridate' was built under R version 4.1.3 \r\n..."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: VF_Reservation.

2 Replies

  • bring your R setup up to the latest version, reinstall the packages.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jisuk_kate ,

     

    Based on your description, I noticed that the R script version you are currently using is 4.1.3 and the current version of R supported by Power BI Desktop and Power BI Services is version 3.4.4.

    For the article ,you may refer to Create Power BI visuals using R - Power BI | Microsoft Learn

     

    Hope it helps!

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.