AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier (Guest Post)

March 28, 2017 by Tim Rodman

Prior to Acumatica 6, you couldn’t embed Power BI Reports inside Acumatica. But that didn’t stop Blair Hurlbut (Catapult) from finding a way.

Guest post by Blair Hurlbut from Catapult

Quick intro from Tim: I talked with Blair after this session at the Acumatica Summit last month and he reminded me that we met at Summit 2016 in Orlando (I have a hard time remembering everyone at these summits, sorry about that Blair). Back in Orlando, Blair had mentioned to me that he found a way to embed a Power BI report inside Acumatica version 5; this is before it became supported in version 6. Then at Summit this year in San Diego, he reminded me and this time offered to do a guest post showing how he did it. Thank you so much Blair! One thing to note is that it requires the report to be published publicly (click here for more info), but I’m still not 100% sure how “public” it really is since the link that you get back would be next to “impossible” to guess. Hey, “impossible” seems like a good intro for the post. Take it away Blair!

Those of you using older versions of Acumatica – anything pre 6.0 – are well aware of the fact that these versions lack Power BI integration, making the task of publishing Power BI reports within Acumatica “mission impossible.” But wait…

While working with one of our Acumatica clients, Tourism Vancouver, we were able to find a work-around to this common issue. Like Tom Cruise’s character – no mission is impossible for us.

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Good morning, Catapult. Your mission, should you chose to accept it is…

To enable the users at Tourism Vancouver to view Power BI reports in Acumatica 5.2. The way we saw it, we had two options:

  1. Give all users access to Power BI
  2. Publish the Reports

The first option wasn’t ideal as it would lead to inefficiencies – requiring users to log in and work in two separate systems. The second option was therefore more promising. But how to do this? By publishing the Power BI reports via Wiki Pages within Acumatica.

Note: This approach assumes that you are using connectors to channel your data from Acumatica into Power BI.

 

Ghost Protocol: Our Work-around

Our approach is simple. Once you have created a report in Power BI all you need to do is publish it to the web and generate an embed code. Then, head to Acumatica and create a new wiki Article. Paste the embed code generated in Power BI into this article. Hit Publish and you are ready to go!

Here are the step by step instructions:

In Power BI

First, create your report in Power BI

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Second, click File and select Publish to Web

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Third, click Create embed code

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Fourth, select Publish

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Fifth, select a size and copy the iFrame url

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

In Acumatica

Go to Organization and click on the Dashboard Tab. Select Create new article.

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

Assign the Article ID and Name. Paste the URL generated in Step 5 into the body section and click Save. In our example we gave the wiki article the name “Sample Power BI Report.”

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

And presto! You will now see the wiki article listed in the list of dashboards.

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

To download a PDF copy of these instructions, click here!

This message will self-destruct in 5 seconds: Pros and Cons

Like any Mission Impossible film, this method definitely has its pros and cons. Although unlike films, the pros outweigh the cons (if you’re reading this Tom Cruise, we’re sorry).

Let’s start with the pros. Firstly, this approach provides users with a centralized system to work in, consequently removing the need for them to move back and forth between systems. While this may seem inconsequential, it’s a huge win for people who live in Acumatica as it makes their user experience much more efficient. Secondly, Power BI is pretty inexpensive, making it accessible to businesses of all sizes (US Pricing available here). Thirdly, it’s very flexible in terms of data collection. Even if your data is coming from systems other than Acumatica, it’s incredibly easy to include this in your reports. Lastly, it allows for the creation of sitemaps to assign different security levels to different users.

In sum: This approach creates a centralized, cost-efficient system with the flexibility to collect data from a number of sources and the ability to assign a variety of security levels.

Now, onto the cons. The major downside to this approach is that users can share the URL with basically anyone. It therefore goes without saying that if you take this approach, you may not want to include sensitive data, such as competitive advantage data.

While not necessarily a con, it’s worth mentioning that this work-around becomes obsolete in Acumatica 6.0. This version supports the publication of Power BI reports. Another reason to consider an upgrade!

 

Conclusion

A big thanks to Tim for giving us the opportunity to do a guest post at augforums.com. This blog is a great resource for all things Acumatica and we’re pretty thrilled to have the opportunity to share some of our expertise here.

Maybe even as excited as Tom on Oprah’s couch?

Mission not so impossible: Publishing Power BI Reports in Acumatica 5.3 and Earlier

 

All kidding aside, if you have any questions or comments above the above approach please don’t hesitate to get in touch with us. We’d love to hear what you think about this work-around!

2017-03-25-02-53-46

Blair Hurlbut is the ERP Practice lead at Catapult. With his hands-on experience in the non-profit sector and sharp business instincts, Blair can deliver Acumatica, Dynamics NAV and Serenic Navigator solutions for businesses and non-profit organizations that are agile and respect the bottom line. He lives, eats and breathes lean deployments that help customers realize business improvements that can be sustained over time.

Catapult delivers support and implementation services for leading ERP and CRM solutions that enable midsized businesses to perform at their best. Located in Vancouver, Canada, Catapult drives outcomes that matter through the provision of software and consulting services including deployment, customization, upgrades, training and support for Acumatica Cloud ERP, Microsoft Dynamics NAV and Microsoft Dynamics 365. For additional ERP and CRM insights follow Catapult on Twitter and LinkedIn or subscribe to our newsletter.

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Learning, Acumatica Summit 2017, Acumatica Training, Embedding Power BI, Power BI, Power BI Reports

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

Online Members

Recent Blog Posts

  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • Acumatica Payroll PTO Banks adjustment

    Has anyone figured out how you would make a manual entr...

    By MSylvia, 3 hours ago

  • Best Practices/Suggested Processes for Before and After Acumatica Version Upgrade

    We have a process in Sage 100 where we will run various...

    By CLove26, 4 hours ago

  • Denominated Currency Accounts, Foreign Currency and Project Accounting

    I'm noting this here for some future reference. I've s...

    By megan.friesen, 4 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    I tried a simple test in 2020R1 and 2020R2 and it doesn...

    By AhmedBahar, 6 hours ago

  • Combining Bill Retainage Invoices to one AR Invoice in Construction

    Hi was wondering if anyone has come up with a good work...

    By Mike Baio, 11 hours ago

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 13 hours ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 1 day ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 1 day ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 1 day ago

Recent Tweets

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.