Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Franklyne
Regular Visitor

Connect BigQuery - R - "EvaluateNativeQueryUnpermitted failure:

 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.

 

Capture.PNG

 

2 REPLIES 2
guibenassi
Advocate II
Advocate II

guibenassi
Advocate II
Advocate II

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors