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

Error

I am trying to access this website ConsultsByOrderDate - Power BI Report Server (va.gov)

 

I am getting the error 

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
      • The target principal name is incorrect. Cannot generate SSPI context.
1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @ReneeLindsey589 ,

 

Has your device installed the Windows OS patch released on November 9th, 2021? It may impact Kerberos delegation.

 

Reference: Windows 10, version 1809 and Windows Server 2019 | Microsoft Docs

 

Resolution: This issue was resolved in the out-of-band update KB5008602 released November 14, 2021. It is a cumulative update, so you do not need to apply any previous update before installing it. To get the standalone package for KB5008602, search for it in the Microsoft Update Catalog. You can import this update into Windows Server Update Services (WSUS) manually. See the Microsoft Update Catalog for instructions. Note KB5008602 is not available from Windows Update and will not install automatically.

 


Please check if the above solution work for you.

 

If not, please try this:

 

Delegation setting for the SSRS/PBIRS service account is set to constrained delegation: "Trust this user for delegation to specified service only" --> "Use any authentication protocol".

Icey_0-1637894806535.jpeg

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @ReneeLindsey589 ,

 

Has your device installed the Windows OS patch released on November 9th, 2021? It may impact Kerberos delegation.

 

Reference: Windows 10, version 1809 and Windows Server 2019 | Microsoft Docs

 

Resolution: This issue was resolved in the out-of-band update KB5008602 released November 14, 2021. It is a cumulative update, so you do not need to apply any previous update before installing it. To get the standalone package for KB5008602, search for it in the Microsoft Update Catalog. You can import this update into Windows Server Update Services (WSUS) manually. See the Microsoft Update Catalog for instructions. Note KB5008602 is not available from Windows Update and will not install automatically.

 


Please check if the above solution work for you.

 

If not, please try this:

 

Delegation setting for the SSRS/PBIRS service account is set to constrained delegation: "Trust this user for delegation to specified service only" --> "Use any authentication protocol".

Icey_0-1637894806535.jpeg

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

d_gosbell
Super User
Super User

You will need to contact the IT helpdesk at va.gov for this issue. This is not really something we can help with on the public community forums, it looks like you possibly do not have the correct permissions to the source data.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!