cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iamironman11111
Frequent Visitor

Not able to save report to Power BI on-premises server

TL DR;

Not able to publish report from "Microsoft Power BI report server" to "Microsoft Reporting Server/Portal" only when I try to publish from another PC In the domain.

 

Hello Community,

 

Hope everyone is doing great!

 

I have a quick question which I have been debugging with the help of Power BI community blogs. 

 

Architecture:

1st VM - For managing Domain Name Server and users (OS - Windows Server 2019). Let's call it 'Domain Server'.

iamironman11111_0-1668158281610.png

2nd VM - Installed SSRS and PBIRS (OS - Windows 10). Let's call it 'Windows 10' VM.

iamironman11111_1-1668158414609 (1).png

3rd VM - Client machine for installing Power BI report Builder. Let's call this machine 'Client' VM. 

iamironman11111_2-1668158566313 (1).png

 

 

I am able to publish (save as -> power bi report server) from my Windows 10 VM but not from client VM. Community, can you please guide us in right direction.

 

Thanks

1 ACCEPTED SOLUTION
iamironman11111
Frequent Visitor

I have been able to do it. No blogs, or videos have told about this. So, I explored and found that I was missing out on giving important permissions.

 

Steps to give permission:

  1. Open Power BI report portal URL
  2. Click on "Manage folder option"
    iamironman11111_0-1669026653713.png

     

  3. Type the name of the user and give the permission to publish (for testing give all of the permissions)
  4. Login into client machine with credentials of that user at the time of publishing and open Power BI (RD version)
  5. Create a demo file and click on "save as" -> power bi report server -> enter IP address and click on save.

 

So, having the 

View solution in original post

3 REPLIES 3
iamironman11111
Frequent Visitor

I have been able to do it. No blogs, or videos have told about this. So, I explored and found that I was missing out on giving important permissions.

 

Steps to give permission:

  1. Open Power BI report portal URL
  2. Click on "Manage folder option"
    iamironman11111_0-1669026653713.png

     

  3. Type the name of the user and give the permission to publish (for testing give all of the permissions)
  4. Login into client machine with credentials of that user at the time of publishing and open Power BI (RD version)
  5. Create a demo file and click on "save as" -> power bi report server -> enter IP address and click on save.

 

So, having the 

v-caitlyn-mstf
Community Support
Community Support

Hi @iamironman11111 ,

 

Are the local desktop machine and the report server on the same domain? 

The PBI desktop automatically submits it's inherited credentials to the report server when asked to authenticate.  If the server can't authenticate your local logged-in user, it'll kick back that error.

 

Best Regards,
Community Support Team _ Caitlyn

yes they are on same domain

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.