Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
alqithmi
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
d_gosbell
Super User
Super User


@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
d_gosbell
Super User
Super User


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

KBO
MVP

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.