Barry Crowell’s Next Post on Dynamics GP & Power BI


Another excellent article from Barry Crowell on Dynamics GP and Power BI:

During my last blog post, I walked you through creating a financial dashboard using Power BI with Dynamics GP data. I have created additional analysis and measures now. If you look closely at the bottom left, you will see two additional reports for Sales Summary and Customer Analysis. Sales Summary The data used from Dynamics […]

via Supercharge Your Dynamics GP Dashboards & Reports with Power BI — My quest in SQL, BI & Dynamics GP

Advertisements

Barry Crowell’s Excellent Dynamics GP & Power BI Post – Multicompany Financial Dashboard


Back in October of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download here. The problem with his solutions is that most Dynamics GP environments are multi-company setups making these dashboards not very functional without navigating and opening multiple Excel spreadsheets to view each company’s […]

via WOW! A Dynamics GP multi-company Financial Dashboard – Part Deux — My quest in SQL, BI & Dynamics GP

GP2016 – Feature of the Day – Power BI Integration & Budget Import Enhancement


Another set of feature of the day posts reveal that Power BI is coming to GP.  Also we have got Budget Import enhancement. Links to the posts are below:

  • Duplicate Accounts Import Exception Report
  • Power BI Reports on Home Page – I would rather like to see Dynamics GP being added to the Power BI Connector Services. Don’t get me wrong. I love this feature, it’s great to have Power BI report widgets on GP home page. However, the ideal integration would be to see Dynamics GP Connector Service. I think that would possibly happen soon, considering the next feature.
  • Dynamics GP OData Service – This is going to be another important feature (HTML5 Web Client being the first one) that I have been waiting for. This will enable us to have an excellent Power BI integration. I am happy to see Power BI reports on GP Home Page, no doubt, but I am super excited about OData Service.

VAIDY