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
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

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.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.