By using this website, you agree to our Terms of Use (click here)
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
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:
- Register Acumatica for Power BI following this guide: https://help-2017r2.acumatica.com/Wiki/(W(4))/ShowWiki.aspx?pageid=0b174aab-ae96-4b7d-aa8d-df83bdb06292
- 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.
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/
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
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?
Strange. I haven't used this in a while. I wonder if Acumatica is keeping up on it.
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:
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?