question

MarcBergmans-8619 avatar image
0 Votes"
MarcBergmans-8619 asked ZoeHui-MSFT edited

Messages when refreshing Power Excel Query with calling in Excel Variable and a Query to collect data From an Oracle Database.

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 this 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.
94952-external-data-source-warning.png94953-external-data-source-run.png
My Best Regards,


power-query-not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MarcBergmans-8619. When I have a minute, this case is pending your feedback (can help others who search here & there before posting). Thanks


0 Votes 0 ·

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered

Hi @MarcBergmans-8619

For the 2nd point (Native Database Query). Within Excel > Data (tab) > Get Data > Query Options > GLOBAL > Security > Uncheck "Require user approval for new database queries"
NB: Options are per installation. So, if you share your workbook with friends/colleagues they must uncheck the same option

For the 1st point (Excel Security Notice) I'm not sure at all but it if doesn't go away after applying the above change try, within Excel > File > More > Options > Trust Center > Trust Center Settings > External Content > Security settings for Data Connections > Choose option "Enable all Data Connections (not recommended)"

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.