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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Adeeb92
New Member

Can not create or assign a schedule refresh plan to a report

 
Hi all,

 

We have Report Server January 2022 release version 1.13.8054.40.361(Build 15.0.1108.153).

I'm able to create a new shared schedule from site setting. However, i can not create or assign an existing shared schedule to a dashboard. I get an error message: An error has occurred. Something went wrong. Please try again later.

 

Adeeb92_0-1670490876717.png

 

 

 

The connection to the data source is set and connectivity is successful.

The error in RSPortal log file shows: |ERROR|132|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

 

The report server is configured to use a virtual service account as a service account. For report server database the credintials are set to SQL account and both the sql account and service account have the proper roles in database.

 

authentication types in reportserver.config file are set as below:

 

 

 

Can you please help me to resolve this issue ?

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @Adeeb92 ,

Pls take the below steps:

  •  generate machinekeys and put them in both rsconfig & machine.config. Then restart both nodes
  •  SSL -Offloading must be done by the loadbalancer e.g. F5. The windows networt balancer would never work. I tried it and had to switch to F5
  •  the BackConnectionHostNames entries must be existing on both nodes for the servername only, fqdn, ssrs main page
  • activate session persistance on the load balancer 

 

refer:

https://community.powerbi.com/t5/Report-Server/PowerBI-Report-Server-The-request-failed-with-HTTP-st... 

 

 

Best Regards

Lucien

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.