cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Question: Can I limit access to Azure SQL Database for Power BI Desktop Application ONLY?

We recently started using Power BI and I was wondering if we could limit the Power BI application to ONLY access the SQL Azure database. For example, the users have both the Power BI application and the Excel 2016 application on their desktop. Both applications can access the same SQL Azure database. However, we only want our users to be able to access the sql database using the Power BI desktop application (not Excel 2016). Any suggestions?

 

Thanks,

 

zbox99

2 ACCEPTED SOLUTIONS
Frequent Visitor

I'm not aware of any technical possibilities to limit Power BI Desktop to a particular data source. But instead of finding "how?", I would suggest to first understand "why?". I believe one of the greatest feature of Power BI is ability to perform easy data integration by user themselve without involving IT every single step. Limiting data source will completely defeat major Power BI purpose.

 

I would suggest to approach this from management point of view rather than technical point of view, such as:

  • What are the damages user would cause by using Excel 2016 data source?
  • Why would the user use Excel data source, if Azure SQL Database have all the data they would need?
  • Did you explained the consequence of improper use of Excel data to the users?
  • Is there any other way you and your user to find a common ground between flexibility and prevention of misuses? - a training, a policy, or an agreement, perhaps.

 

View solution in original post

Impactful Individual
Impactful Individual

I doubt you will be able to do this. The permission itself is on the database, not the application.

 

Our company is restricting database access to only a small number of key users... essentially people who know what they're doing. Hence, these users should be smart enough to know when to use Excel/Power BI to access Azure.

 

A lot this comes down to policy and governance to ensure users know what they should be doing.

 

Regrds,

DJ

 

 

View solution in original post

2 REPLIES 2
Impactful Individual
Impactful Individual

I doubt you will be able to do this. The permission itself is on the database, not the application.

 

Our company is restricting database access to only a small number of key users... essentially people who know what they're doing. Hence, these users should be smart enough to know when to use Excel/Power BI to access Azure.

 

A lot this comes down to policy and governance to ensure users know what they should be doing.

 

Regrds,

DJ

 

 

View solution in original post

Frequent Visitor

I'm not aware of any technical possibilities to limit Power BI Desktop to a particular data source. But instead of finding "how?", I would suggest to first understand "why?". I believe one of the greatest feature of Power BI is ability to perform easy data integration by user themselve without involving IT every single step. Limiting data source will completely defeat major Power BI purpose.

 

I would suggest to approach this from management point of view rather than technical point of view, such as:

  • What are the damages user would cause by using Excel 2016 data source?
  • Why would the user use Excel data source, if Azure SQL Database have all the data they would need?
  • Did you explained the consequence of improper use of Excel data to the users?
  • Is there any other way you and your user to find a common ground between flexibility and prevention of misuses? - a training, a policy, or an agreement, perhaps.

 

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors