User Profile
jisuk_kate
Advocate I
Joined 4 years ago
User Widgets
Contributions
Re: ODBC: ERROR [HY000] [Treasure Data][Presto] (1060) Presto Query Error: Too many queued queries
amitchandak I am faced with ' Presto Query Error: Too many queued queries ' errors. I am trying to follow your guides of the above. Go to File-> Options and settings -> Options -> Load ->an option for parallel queries , reduce that number and try The below is what you are talking about? If then, I reduced the number but stil doesn't work. If not, would you let me where I should change in the below.? Looking forward to your advice.!!!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.Re: Starting from today datasets conctaing R script can't be updated (Unable to detect a gateway)
HI Community Support Team _ Ailsa Tao, In some of posts, I could see some of them are reworking without further action from the user side. But mine is still not working. Now I am very concerned. it can be fixed.,...??Re: Starting from today datasets conctaing R script can't be updated (Unable to detect a gateway)
I have the exact same issue. What information we should provide for your investigation? all of sudden, starting from yesterday, all Power BI reports including ODBC and rscript don't work If I click 'Datasets' the below error message popped up. If I click Gateway connection, gateway is not shown. I uninstalled and reinstalled Power bI desktop & Gateway. But it doesn't work still
