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

Get Data from Power BI Sever to Power BI desktop

Hello everyone,

 

We are going to install PBIRS on our organization, and we expect that the server will be used by a large number of users. Our users will use a variety of data sources to create their reports. 

 

It will be difficult to set-up network access from each used data-source to both PBIRS and the users' local PCs.

 

Thus, is there a way to connect the different data sources only to the Power BI server, and then make the users get the data to their Power BI desktop from the Power BI server? (without having any connection between the user's local PC and the data source directly)

 

For example, PBIRS has access to "X database", and user A does not have access to the X database but he has access to the PBIRS. User A can create a new report on his power BI desktop, and he can import the data from the X database to his report only by using the access that he has to the PBIRS without having a direct access to the X database.

 

 

 

Thank you so much in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Get Data from Power BI Sever to Power BI desktop


@alqithmi wrote:

For example, PBIRS has access to "X database", and user A does not have access to the X database but he has access to the PBIRS. User A can create a new report on his power BI desktop, and he can import the data from the X database to his report only by using the access that he has to the PBIRS without having a direct access to the X database.

 


No you cannot do this.

 

If UserB has access to X database, they can build a report and publish it to the server and UserA can view that report on the server, but UserA would not be able to build or edit reports in PowerBI desktop without having direct access to X database. 

 

You cannot bypass security/network restrictions on X database using Report Server.

 

Often the solution in this case is to build a Data Lake or Data Warehouse or as @KBO suggested, to build some SSAS cubes that people can hit without going directly to the source databases. 

View solution in original post

2 REPLIES 2
Highlighted
Memorable Member
Memorable Member

Re: Get Data from Power BI Sever to Power BI desktop

Hi @alqithmi ,

sounds like you can need a SSAS Cube ;).

Try to build first the datamodel and after that you can build different reports on it. Its the same like a dataset in Power BI Service. You can also set RLS on this cube to restrict the access.

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Highlighted
Super User III
Super User III

Re: Get Data from Power BI Sever to Power BI desktop


@alqithmi wrote:

For example, PBIRS has access to "X database", and user A does not have access to the X database but he has access to the PBIRS. User A can create a new report on his power BI desktop, and he can import the data from the X database to his report only by using the access that he has to the PBIRS without having a direct access to the X database.

 


No you cannot do this.

 

If UserB has access to X database, they can build a report and publish it to the server and UserA can view that report on the server, but UserA would not be able to build or edit reports in PowerBI desktop without having direct access to X database. 

 

You cannot bypass security/network restrictions on X database using Report Server.

 

Often the solution in this case is to build a Data Lake or Data Warehouse or as @KBO suggested, to build some SSAS cubes that people can hit without going directly to the source databases. 

View solution in original post

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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.