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
peterbrayton
Frequent Visitor

report embed problem

   We have successfully registered our 2016 Reporting Services with power BI on the server.

  When we try and pin a report part to the power bi site, it asks us to log into power bi.  We click on the account name.  Then it tries to redirect to our site.  Then we get this.  Has anyone gotten this error and is there asolution to correct?

 

Sign In

 

   Sorry, but were having trouble signing you in.  We received a bad request.

 

Additional technical information:
Correlation ID: 87fe19af-d28a-4d1e-ab3f-1c2722caf11e
Timestamp: 2016-09-02 15:00:07Z
AADSTS90093: Does not have access to consent

 

1 ACCEPTED SOLUTION

Hi @peterbrayton,

 

Please check if you have a dashboard created in Power BI Service My Workspace. If not, please create a new dashboard. Or create a Group workspace and create a dashboard in this group to see if you can pin the SSRS visual to Power BI Dashboard.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

5 REPLIES 5
peterbrayton
Frequent Visitor

Hi

 

   So the resolution for us was that Azure Active Directory (AAD) access was needed.

We enable “Integrated Apps” within AAD and then we were now getting the prompt to allow the app, and got successfully signed in.

 

   Unfortunately now we have another problem with it saying I do not own any dashboards to pin to, even though I do and we do have power bi pro.  Working with microsoft now for that issue...

   Hope this helps someone else

 

Regards,

 

Peter.

 

Hi @peterbrayton,

 

Please check if you have a dashboard created in Power BI Service My Workspace. If not, please create a new dashboard. Or create a Group workspace and create a dashboard in this group to see if you can pin the SSRS visual to Power BI Dashboard.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes,

 

   We had to add a group then a dashboard.  Without a group, it wasnt working.  Now is working.  Thank you all for your help!  Greatly appreciated!

 

Regards,

 

Peter.

 

bjmorse
Regular Visitor

Also had this error message and turned out that the company firewall was blocking. Try same call on a public or home internet connection. Worked for me.

v-qiuyu-msft
Community Support
Community Support

Hi @peterbrayton,

 

According to your description, when you pin the report item to Power BI, it will prompt you enter Power BI credential. Once you enter the account, it will throws an error, right?

 

In your scenario, please use entered account to access Power BI service, verify the account is valid. Then please sign in the Power BI account in My Settings to see if it can be successful. Please refer to this article: My Settings for Power BI Integration (web portal).

 

In addition, as the error message doesn't contain insufficient information, please check the Reporting Services error log (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles) around the time that the error message thrown out. Please post the detail error log for our analysis if possible.

 

Reference:

Pin Reporting Services items to Power BI Dashboards

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.