Skip to main content

I've Got the Power (Query)

Have you seen Power BI reports and thought, “hey, I want that, but I’d prefer to work in Excel”? If so, you’ve come to the right place.

Power BI might get all the attention for creating visually impactful interactive reports these days, but did you know that the same data engine also lives in Excel?

That’s right. You, too, can create stunning reports, without Power BI, directly from your Excel spreadsheets, and I will show you how. In this session, Ramin will show you how to use the Power Query function in Excel to refresh and dynamically report on data from your Business Central instance. 

Ramin will be covering:

  • Exposing web services from Business Central
  • Pulling them into Excel
  • Transforming them
  • Linking them together
  • and creating quick calculations (measures) in Power Pivot

Join me, as I help you create visually stunning reports that better convey your data’s story and engage your viewers for better decision-making.