Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am running R script on my PowerBI desktop app for some reports I manage.
These reports are published online and are set on scheduled refreshes through the personal gateway.
Recently, I upgraded my machine to have the latest R version 4.3.0. from 3.6.3. Then, I no longer am able to refresh these online reports. Below message is a type of error I get - saying that there's no package called tidyverse. But I can refresh my reports through my PowerBI desktop app without any issue loading in tidyverse package from R and refresh every component of my reports. These refresh failures only happen with the scheduled refreshes or when I click refresh button on the datasource online. So, now I am wondering if the personal gateway somehow doesn't support the latest R version for its script? I can't seem to find the exact answer anywhere...
Error:
Data source error: {"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\nError in library(tidyverse) : there is no package called 'tidyverse'\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\nError in library(tidyverse) : there is no package called 'tidyverse'\r\nExecution halted\r\n"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: se_ho_final.
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: c70f0060-7024-422e-a687-2dcd20415db1
Request ID: 95949f5f-1bb4-e7ff-359f-7d6a2c0fafbf
Time: 2023-05-30 15:01:06Z
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.