I've Got the Power (Query)
FREE Membership Required to View Full Content:
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here
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.