Failure with R script data access in power BI

[Anonymous]

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?

[Anonymous]

Hi @Anonymous 

I found some blogs about R script as data source in Power BI Desktop.

For reference:

R script as data source in Power BI Desktop

Run R scripts in Power BI Desktop

This may be the same issue like yours, I hope it can help you.

R Script returning empty table

Best Regards,

Rico Zhou

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