MADIC dynamics Knowledge Hub Webinars: Reporting with Business Central

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at Reporting with Business Central.

If you want to catch up on this webinar, you can do so here.

  1. Introduction
  2. List Pages
  3. Standard Reports
  4. Financial Accounting
  5. Jet Reports
  6. Jet Analytics
  7. Power BI
  8. 3rd Party BI
  9. Conclusion

Introduction ^

In this webinar we took an introductory look at the reporting tools which come with Microsoft Dynamics 365 Business Central as standard, such as list pages, standard reports and financial reporting, as well as then taking a look at the commonly used third-party reporting tools which include Jet Reports and Power BI.

Continue reading “MADIC dynamics Knowledge Hub Webinars: Reporting with Business Central”

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Feb-Apr 2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting the first few webinars, but in future other consultants will be getting involved, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available; the webinars are open to everyone, not just customers of MADIC dynamics. The next three webinars, starting this month, are:

No february-2024 events found.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Feb-Apr 2024) from MADIC dynamics

Extending Business Central with Power Automate

Tuesday, 19th March 2024 – 14:00-14:45

Learn how Business Central can be extended with Power Automate, from approvals to process automation to document distribution.

Register Here

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Feb-Apr 2024) from MADIC dynamics

Jet Reports & Business Central

Tuesday, 16th April 2024 – 14:00-14:45

Learn how Jet Reports can be used to increase your financial and operational reporting capabilities from Business Central.

Register Here

New Functionality In Microsoft Power Automate 2024 Wave 1: View a Power Automate Visual in a Power BI Report

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 1.

The 3rd of the new functionality in the Cloud Flows section is view a Power Automate visual in a Power BI report.

This feature helps you translate insights to action. With Power Automate visual, you can run an automated flow from a Power BI report. Furthermore, the executed flow can be data contextual, passing in dynamic data based on the filters you set.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
Early Access: –
General Availability: Apr 2024

Feature Details

When you create a Power Automate visual in a Power BI report, your users can run an automated flow, just by selecting a button in your report. The flow can be data contextual, meaning that the flow inputs can be dynamic, based on the filters the users set.

You can later edit the flow with different data fields to use as data inputs. You can also change formatting, such as button text, font color, font size, or fill color of the button. You can enable permission for any user to edit the flow, in addition to running it.

This feature is currently in public preview and documented in Create a Power Automate visual for Power BI (preview).

With the general availability update, you can see flows outside the Default environment and support for all regions Power Automate is available in.

My Opinion

This sounds interesting. It gives the users to initiate a flow from a Power BI report or dashboard. The linked article from the Power BI side shows how it can be setup and configured.

Recent ISC Software Webinar: Business Intelligence with Microsoft Dynamics GP

ISC Software SolutionsIn our most recent webinar, we took a look at Business Intelligence with Microsoft Dynamics GP. In this webinar, we covered how business intelligence can be used with Microsoft Dynamics GP. If you want to catch up on this, or any other, webinar, you can do so here.

  1. Introduction
  2. What is Business Intelligence?
  3. What is Jet Analytics?
  4. Reporting options with Jet Analytics
  5. What is Power BI?
  6. Reporting options with Power BI
  7. Conclusion

Introduction ^

I think this webinar was the first one in which we didn’t even open Microsoft Dynamics GP. This because this webinar focused on how business intelligence can be used with Microsoft Dynamics GP. We focused on two business intelligence products which can be used to quickly build required dashboards and reporting for business intelligence.

The two products we looked at are complimentary and can be used both together or independently. They are Jet Analytics and PowerBI

Continue reading “Recent ISC Software Webinar: Business Intelligence with Microsoft Dynamics GP”

Microsoft Dynamics GP PowerBI Content Pack

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has recently been released. and I have been taking a hands on look at the installation (and soon the new functionality). The series index for the Hands On series of posts is here and will automatically update as posts go live.

This post is not part of the hands On series, mainly because I currently have little experience with PowerBI (Perfect Image have a Business Intelligence team who do most of the PowerBI work).

It was announced some time ago that there would be a Microsoft Dynamics GP content pack for PowerBI available. I’ve not seen any blog announcement on it, but Pam Misialek did tweet back in December 2017 that it was now available.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

Dynamics GP Tech Conference 2017: Power BI Enhancements

Microsoft Dynamics GPMicrosoft Dynamics GPThis post is part of the series I am doing on the Dynamics GP Tech Conference 2017.

Power BI is more the area of Belinda Allen or Mark Polino than mine, but I’ll be getting more of a look at it soon as I have one of my team about to take a more in depth look, so it is nice to hear there will be more new stuff coming in the next version of Dynamics GP:

  • Support for paging in OData Services
  • Support for filtering in OData Services
  • Support for OData v4
  • GP Power BI Content Pack – I need more information on this, but it sounds like a set of pre-packaged reports which will be welcome.

MDGP 2016 R2 Feature of the Day: PowerBI On The Web Client Home Page

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The twentieth Feature of the Day is PowerBI On The Web Client Home Page.

Power BI on GP Web Client Home Page

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: PowerBI Reports on the Home Page

In February 2014 Microsoft launched PowerBI for Office 265 and are now bringing it to the Microsoft Dynamics GP 2016 R1 home page (but only the home page of the desktop client):

PowerBI on the Microsoft Dynamics GP 2016 R1 home page

The main features of are:

  • New part on Home Page to display Power BI Reports.
  • Click on the report to take you out to your Power BI site.

I’m not entirely sure how to feel about the addition of PowerBI to Dynamics GP; it almost feels like a scatter gun approach is being used for reporting with Dynamics GP. There are standard reports, Metrics, Excel Reports, SSRS Reports (which for most clients replace the Metrics to the extent I had to lookup the name of Metrics), Management Reporter (with an unknown roadmap/future) reports and now PowerBI reports.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index