Forum

Join Queries that c...
 
Notifications
Clear all

Join Queries that collect variables from Excel and will be used in a sql to gather data from an Oracle Database in one query.

2 Posts
2 Users
0 Reactions
147 Views
(@marcberg)
Posts: 23
Trusted Member
Topic starter
 

Hello,

 

I'm getting messages when i refresh a query that calls up a variable which is formed in Excel and when refreshing a query that collects data from an Oracle Database through a sql in the Query.

 

The messages that I get are in attachment.

The Title of the first is Microsoft Office has identified a potential Security concern. The operation connects to an external data source.

The second Native Database Query Do you approve running tOverview-Variables-Excel-and-Queries-1.pngQuery-Current.pnghis native query ?

 

Can someone tell me If i can get rid of these messages ? I want to run the queries automaticcaly so i don't want popup messages that interrupts the automated process.

 

Thank You In Advance.

 

My Best Regards,

 
Posted : 09/05/2021 10:56 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Marc,

I'd say this is down to your privacy settings for this query. Open the query and go to the File tab > Options & Settings > Data Source Settings and edit the permissions, setting the Privacy Level to none.

Mynda

 
Posted : 10/05/2021 7:55 pm
Share: