cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fooksie
Advocate II
Advocate II

SSRS Report Authoring in Visual Studio 2019 Preview Fails to Authenticate

Let me start with HELP!  I've tried everything I can find.

 

I'm trying to author new SSRS reports for our PowerApps model-driven app and I can author them fine, but when I go to preview the report in VS2019 is fails to authenticate and gives me the error: 

 

"You don't have permission to access any of the organizations in the Microsoft Common Data Service region that you specified. If you're not sure which region your organization resides in, choose "Don't know" for the CDS region and try again. Otherwise check with your CDS administrator."

 

I have System Administrator role in the environment and I'm the PowerApps Admin and Global Admin in the O365 tenancy.  I don't think it's a permissions issue.

 

I've setup my workstation according to the guide outlined here, Set Up Your Workstation to Create SSRS Reports for Dataverse and it worked great for a while.  But recently something's changed and now I cannot preview any report in the dev environment without hitting that authentication error.

 

I've Googled the heck out of this and have tried EVERYTHING that's been suggested but nothing helps.  I can deploy the report into PowerApps and preview it there fine but it really really slows down the development cycle.  Is anyone else having this issue and what have they tried to resolve it?

 

My thought is that the D365/PowerApps SSRS extension team is behind the release 8-ball with the security changes relating to TLS 1.2 but that's just a suspicion at this point.  HELP PLEASE

2 REPLIES 2
cchannon
Super User
Super User

I assume you've tried signing in again?

Yes.  That was the first thing I tried.

 

I don't think it has anything to do with Visual Studio and the credentials used to log into VS, but rather changes to PowerApps/D365 and the way the VS Reporting Projects Extension uses the FetchXML Report Authoring Extension and passes THOSE credentials (which you enter in a separate window from the VS credentials) over to PowerApps/D365 and how it handles the response.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,362)