cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WranglingData
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION
parry2k
Super User III
Super User III

@WranglingData 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
v-robertq-msft
Community Support
Community Support

Hi, @WranglingData 

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
Super User III
Super User III

@WranglingData 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.