AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica OData wit...
Embedding Power BI ...
 
Notifications
Clear all

Embedding Power BI Reports in Acumatica - Reply Address Error  

Page 2 / 2 Prev
    Last Post
RSS

Alec Menconi
Posts: 2
 Alec Menconi
November 28, 2019 12:42 am
(@alec-menconi)
Member
Joined: 1 year ago

Hello,

Very glad I found this resource.  I am having similar issues.  I'm using free version of Power BI through my company's office 365 account and using Acumatica on version 19.106.0020.  The instance has multiple companies.

I verified I have access to BI role (I am an administrator so I believe I have full access).

I've registered Acumatica with Azure for Power BI and tried every combination of the highlighted fields:

Acumatica Power BI Azure App Reg Settings

Some of the reply URLs I've tried:

  • https://acm.cushnocgroup.com/PowerBI/OAuthAuthenticationHandler
  • https://acm.cushnocgroup.com/OAuthAuthenticationHandler
  • https://acm.cushnocgroup.com//OAuthAuthenticationHandler
  • https://acm.cushnocgroup.com/PowerBI/auth
  • https://acm.cushnocgroup.com/PowerBI
  • https://acm.cushnocgroup.com/PowerBI/auth/OAuthAuthenticationHandler

I beat my head against this for a long time, then tried re-registering it because I remember that the homepage URL I put in the first time was likely not correct and wasn't listed to be changed in Azure...  Tried it again and it let me get one step further confirming I was allowing permission then return the same error again but with some more details "Reply address did not match because of case sensitivity.".  Unfortunately after triple checking it appeared the characters cases between acumatica and azure were identical.

I then tried one more time and got this error (was getting this off and on as I was testing previously):

acu error

Now I can't even replicate the case sensitivity error again and instead get a mix of the aspx error and more general "AADSTS50011: The reply address does not match the reply addresses configured" error.

Any help in this would be greatly appreciated.

Thank you

 

 

 

This post was modified 1 year ago 2 times by Alec Menconi
Reply
Alec Menconi
Posts: 2
 Alec Menconi
November 28, 2019 1:32 am
(@alec-menconi)
Member
Joined: 1 year ago

Well now I feel a bit foolish.  Our instance of Acumatica gets hung loading in Chrome for some reason and Firefox is a bit spotty at times so I was using Edge (ugh).

After registering my Acumatica instance in Azure for Power BI I was able to add a Power BI tile with a report I built, however the report never loaded in the tile.  After trying to get that to work I figured I had to add Power BI as an external app, this is where the problems listed in this post came into play.

What worked for me:

  1. Register Acumatica for Power BI following this guide: https://help-2017r2.acumatica.com/Wiki/(W(4))/ShowWiki.aspx?pageid=0b174aab-ae96-4b7d-aa8d-df83bdb06292
  2. Follow this guide to add Power BI dashboard reports as a Tile Widget: https://help-2017r2.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=66f1e0b1-9c57-4ca5-9332-1e2f112e8935

 

Turns out the tile just wouldn't load in Edge and when I repeated the above steps from scratch in Firefox the tile widget loaded right away.

The reply URL that is currently working for me, and humorously enough was the first one I tried is: https://acm.cushnocgroup.com/powerBI/auth

Hope this saves someone a head ache down the road.

This post was modified 1 year ago by Alec Menconi
Reply
Tim Rodman
Posts: 2517
 Tim Rodman     ★★ All-Star ★★
December 14, 2019 6:58 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Thanks so much for sharing your solution Alex.

Personally I lean towards this option now:
https://www.augforums.com/forums/acumatica-odata-with-microsoft-excel-and-power-bi/a-new-way-to-embed-power-bi-reports-in-acumatica/

Reply
daniel
Posts: 92
 daniel
February 4, 2021 5:44 pm
(@daniel)
51-100 Posts
Joined: 11 months ago

This thread is great. Thank you all so much. Power BI now embedded 🎉🎉🎉

One thing regarding the External Applications page: It now gives me the return URL to use. 

For me this was https://company.myobadvanced.com:443/OAuthAuthenticationHandler

Reply
daniel
Posts: 92
 daniel
February 5, 2021 1:09 am
(@daniel)
51-100 Posts
Joined: 11 months ago

I'm hitting an issue now...For some reason, the embedded graph page is only accessible for administrators?

Is there any particular user security settings that need to be changed here?

Yes I have given Access Rights to other roles on the Application Resources page, but this doesn't seem to change things?

This post was modified 3 weeks ago by daniel
Reply
Page 2 / 2 Prev
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,702 Topics
7,858 Posts
6 Online
1,153 Members

Latest Post: Adding Formulas to Results Columns Our newest member: maxmce Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×