"Require user approval for new native database queries" tick box resets each time I open PBIX file.

[Anonymous]

Hi,

I am currently working on a  report in Desktop that has native SQL queries.  To overcome the permissions warning, I have deselected the tick box on the "Require user approval for new native database queries" options screen.

The problem I am currently having is that the next time I open the PBIX file and work on the report, the tick box has been set back.

Is there any way to stop this from happening?  I am the only person working on this file.

Also, will this be an issue when I setup automatic refreshes?

Thanks

[v-robertq-msft]

Hi, @Anonymous 

Have you tested the automatic refreshes? Does it work?

If the dataset can be successfully refreshed, would you like to mark parry2k’s reply as a solution or share some experience so that others can learn from it too?

If you still have a problem, you can just continue to ask questions in the forum.

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[parry2k · Accepted solution]

@Anonymous no it will not be an issue when you configure the schedule for data refresh.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thanks @parry2k .  I am actually still waiting for my infra guys to setup the gateway for this particular project, so I'll test it then.