AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica OData wit...
Embedding Power BI ...
 
Notifications
Clear all

Questions Embedding Power BI Reports in Acumatica - Reply Address Error

 
Page 2 / 2 Prev
Acumatica OData with Microsoft Excel and Power BI
Last Post by Kurt Keating 1 year ago
25 Posts
9 Users
1 Reactions
25.2 K Views
RSS
Posts: 2
 Alec Menconi
November 28, 2019 12:42 am
(@alec-menconi)
Member
Joined: 6 years 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:

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):

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

ย 

ย 

ย 


Reply
Posts: 2
 Alec Menconi
November 28, 2019 1:32 am
(@alec-menconi)
Member
Joined: 6 years 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.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
December 14, 2019 6:58 pm
(@timrodman)
Famed Member
Joined: 10 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)
Estimable Member
Joined: 6 years 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)
Estimable Member
Joined: 6 years 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?


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
March 15, 2021 5:22 am
(@timrodman)
Famed Member
Joined: 10 years ago

Strange. I haven't used this in a while. I wonder if Acumatica is keeping up on it.


Reply
Kurt Keating
Posts: 4
 Kurt Keating
August 22, 2024 5:47 pm
(@a2thek2)
New Member
Joined: 2 years ago

anyone keeping up with PowerBI Tiles in ACU?ย  ย  I have been beating my head against the wall trying to get any of this to work and I'm not having luck.ย 

I can get ACU to return an error when trying to connect via the external application:ย 

image

But the trace and profiler do not seem to give me much more to go on.ย  I have my powerbi dashboard, I have my app registered...ย  what am I missing?


Reply
Page 2 / 2 Prev
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 16 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
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

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright ยฉ 2025 ยท AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

โ€นโ€บร—

    โ€นโ€บร—