Questions Embedding Power BI Reports in Acumatica - Reply Address Error

Hi Scooter,

The problem has to do with the reply address that you gave in your Step 2.

You have two options.

The first option is simply to go back to  https://dev.powerbi.com/apps and put the following in the Redirect URL field:
http://localhost/PowerBI/OAuthAuthenticationHandler

The second option is more involved, but it gets you more familiar with Azure.

1. Go to https://portal.azure.com

2. Search for "app registrations" on the top, then click on App registrations

3. Change the drop-down to All apps and click on the My Acumatica Test Instance app since that's the name that you gave your app in your Step 2.

4. Click the Settings button

5. Click Reply URLs

6. Change http://localhost/PowerBI to http://localhost/PowerBI/OAuthAuthenticationHandler and click the Save button

Regardless of which option you choose, once you go back to the External Applications (SM301000) screen in Acumatica, you should be able to click the SIGN IN button and see information get populated in the AUTHENTICATION TOKEN area. If you see that, then you're good to go.

Thank you so much!

That got me passed the error message.

I was then able to go to the Application Resources (SM301010) screen in Acumatica, choose the Application ID that I just setup in the External Applications (SM301000) screen, and choose from the options available in the Resource ID field which was a live list of reports available in my PowerBI.com workspace.

After adding it to the Acumatica site map in the screenshot above, my Power BI report now appears right inside of Acumatica and is fully interactive.

Hmmm, not sure what the problem could be. I just checked an https instance that I have running on Acumatica 6.10.0472 and my embedded Power BI report is working fine using the method outlined above.

Is there anymore info or screenshots that you can provide?

Thank you Scooter!!  I'm having the same problem.  Not sure how to enter the url's with multiple companies.  One company is our live system and the other is a training instance.  Problem is compounded by a space in the company name.  Ex.  https://abc.acumatica.com/ABC Live

Any idea how to specify ABC Live in the registration URL's?

Hi Russ,

When it comes to spaces, normally the URL puts in some special characters. Your URL above should get turned into this:
https://abc.acumatica.com/ABC%20Live

But I'm not sure if you're having trouble with the Instance URL or the fact that there are multiple Companies in your Acumatica Instance.

@jose-antonio-romero and I corresponded offline a little. Initially we were thinking that the problem had to do with https, but I was able to get it to work with my https Acumatica Instance. Then we realized that the only difference between his environment and my environment is that my environment did not have multiple Companies in my Acumatica Instance.

So I just tested with an environment that has multiple companies, but I was still able to get it to work:

So it works in an Instance with multiple Companies.

Then I started to wonder if the Power BI Account has to be a Pro account.

But I checked the account that I'm using and it's a Free account:

Now I'm stumped. This is one of those situations where I want to break it, but I can't.

Maybe it has something to do with your Azure account. Can you confirm that you can get to the App registrations area in Azure?

1. Go to  https://portal.azure.com

2. Search for "app registrations" on the top, then click on App registrations

3. Change the drop-down to All apps and make sure that you can see your app listed:

Although not completely relevant to this discussion, it's relevant enough that I thought I would share this article:

http://radacad.com/embed-power-bi-in-sharepoint-online-office-365-integrated-sharing

Even though the article talks about embedding in SharePoint, there is a section that talks about every user needing a $10/user/month Power BI Pro account. It seems like this restriction is built into the SharePoint embedding.

Even though embedding in Acumatica doesn't require a Power BI Pro account on the technical side, legally it's required. And the Acumatica embedding isn't aware of how many Acumatica users actually access the report on the technical side. But legally, my understanding is that every Acumatica user accessing that embedded Power BI Pro Report should have a Power BI Pro Account.

I have no inside knowledge of this, but it wouldn't surprise me if we see embedding in Acumatica function like embedding in SharePoint in the future where the legal restrictions get built into the technical restrictions.

https

://ubp.acumatica.com/ubp live/OauthAuthenticationHandler   It won't even let you save it like this, so we know this won't work.

https://ubp.acumatica.com/ubp&live/OauthAuthenticationHandler       Received the error message below:

https://ubp.acumatica.com/ubp+live/OauthAuthenticationHandler   Same error message as above.

https://ubp.acumatica.com/ubp_live/OauthAuthenticationHandler   Same results

I did confirm I can get to the apps in Azure Portal and I have a PRO power bi account.

What's interesting to me is that there are two slashes in your screenshot which makes it seem to me like it is completely removing whatever you put in.

Looking at this again, I'm not sure you really need anything between .com/ and OauthAuthenticationHandler because https://ubp.acumatica.com  is the path to your Acumatica instance. My link works without putting the company name in the link at all.

Have you tried this in the Redirect URL field:

https://ubp.acumatica.com/OauthAuthenticationHandler

And this Home Page URL field:

https://ubp.acumatica.com

Very strange. Grasping at straws here, but I notice that you have a trailing / after your Home Page URL whereas I don't. Maybe try removing it?

The only other thing I can think is that it has something to do with the Acumatica SaaS environment and you might need to open an Acumatica Support case.

Finally got it to work (well, my Acumatica partner did)......

They had to go into Azure and enter the reply URL.   https://ubp.acumatica.com//OAuthAuthenticationHandler

The simple method (option 1 above) simply would not work.  Also had to put in the double //.  In the end, they didn't have to do anything relating to which company to authenticate with.  That's handled by default on the External Applications page in Acumatica.  

Thanks for all your help!!

Very interesting, especially the part about the double //.

Go partners! Acumatica would be nothing without their partners.

Thanks for sharing the resolution. I'm curious though, how did the partner have access to Azure if you're running on the acumatica.com domain? And isn't Acumatica SaaS running on Amazon, not Azure?

Hi,

I am facing the same problem.  Read through till the end of this thread and added extra / for the ReturnURL.  What I register was:

Redirect URL = http://69.666.994.15/censof//OauthAuthenticationHandler

Homepage URL = http://69.666.994.15/censof

and copied over to External Applications form and clicked on SIGN-IN. 

Error message encountered:

 Sorry, but we’re having trouble signing you in.
AADSTS50011: The reply address 'http://69.666.994.15/censof/OAuthAuthenticationHandler' does not match the reply addresses configured for the application: 'f3b9fb34-a23f-4dfc-85c2-02fe7581b843'. More details: not specified

Any assistance would be greatly appreciated.

Thanks in advance,

Saiful.

OK.  Read somewhere in one of the threads that it would need a newer version of Acumatica for this to work. 

Upgraded from 6.10.0010 to 17.207.0029 and am able to connect successfully.

Perfect. Thank you for sharing your fix for the problem.