cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Creating Database for Users Without Access to SQL Server

Hi,

 

I have a PBI file that connects directly to a SQL server for multiple tables. However, I have multiple users that would like to build on this same database, but do not have access to that SQL server. Is there a clever way to enable these users to access the same database via Power BI without them having access to the SQL server?

 

Thank you in advance for your help. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Creating Database for Users Without Access to SQL Server

Hi,

 

When you use PBI Desktop to connect to SQL Server you must include the login information (data source settings), so each instance of PBI Desktop (on different PC/LT) has to use this information and you must provide it; so you need access through SQL Server authentication (because I understand they can't use windows authentications because they don't have access). 

 

They could develop in the powerbi.com service, using a Dataset previously connected to the data source... 

 

Regards

View solution in original post

Highlighted
Community Support
Community Support

Re: Creating Database for Users Without Access to SQL Server

Hi @PowerBI2020 ,

 

If users need to build report based on SQL Server database, the data source credentials must be provided, and then the access to SQL Server database is required. So there is no other way to implement your demand currently.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Creating Database for Users Without Access to SQL Server

@PowerBI2020 - Possibly. When you say "connect directly" do you mean DirectQuery?

 

If it is DirectQuery, they should be able to use a PBIX file and create measures.

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Resolver I
Resolver I

Re: Creating Database for Users Without Access to SQL Server

Hi,

 

When you use PBI Desktop to connect to SQL Server you must include the login information (data source settings), so each instance of PBI Desktop (on different PC/LT) has to use this information and you must provide it; so you need access through SQL Server authentication (because I understand they can't use windows authentications because they don't have access). 

 

They could develop in the powerbi.com service, using a Dataset previously connected to the data source... 

 

Regards

View solution in original post

Highlighted
Community Support
Community Support

Re: Creating Database for Users Without Access to SQL Server

Hi @PowerBI2020 ,

 

If users need to build report based on SQL Server database, the data source credentials must be provided, and then the access to SQL Server database is required. So there is no other way to implement your demand currently.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors