Failure with R script data access in power BI

Anonymous — Wed, 21 Jul 2021 05:42:49 GMT

Create the following script that is below in R, where I can visualize the data of the table without problems, when trying to execute the same script in Power BI it does not show me data:

#Script in R

library (httr)

library (rvest)

url_params <- parse_url ("https://colombiacompra.gov.co/tienda-virtual-del-estado-colombiano/ordenes-compra?

page = 1 & number_order = & state = & entity = & tool = IAD% 20Software% 20I% 20-% 20Microsoft & date_to _ =% 20 & date_from_ = ")

pages <-
lapply (0:11, function (x) {
data frame (
html_table (
read_html (x = paste0 ("https://colombiacompra.gov.co/tienda-virtual-del-estado-colombiano/ordenes-compra? page =",
X,
"& number_order = & state = & entity = & tool = IAD% 20Software% 20I% 20-% 20Microsoft & date_to _ =% 20 & date_from_ ="))
)
)

})

do.call (rbind, pages)

the results of the R script are as follows:

When running it in Power BI through the R connector the result is the following:

Does anybody know how I can fix it?