Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have been using and R script to "Get Data" scraped from a government site and it had been working until a couple of days ago. When I tried to run a modified script I get the following error:
Unable to Contect
We encountered an error while trying to connect.
Details: "EvaluateNativeQueryUnpermitted failure: the query ' ..... ' isn't approved for execution."
I modified the query to as simple as possible, it seems like Power BI won't run ANY R scripts anymore and I can't figure out why. I can still refresh the the data with query I wrote a couple days ago using the "refresh" button but if i copy and paste the script into the dialog box it won't run.
Maybe there is a better solution is this topic
https://community.powerbi.com/t5/Power-Query/Power-BI-cannot-unload-R-scripts/m-p/480364
I am having a similar error in my database.
I find a turnaround to solve this error.
I was using a parameter in the source and database, I switch to use text and the query works fine.
Hope I can help you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.