Microsoft Fabric Updates Blog

Microsoft Fabric logo
Microsoft Fabric logo

Combining Excel Files hosted on a SharePoint folder with Power BI

Have you ever wanted to consolidate, combine or append data from multiple excel spreadsheets or workbooks? I bet you have, and it has been a painful process either done manually or via 3rd party add-ins. In this blog post, we’ll show you how, with the newest version of the Power BI Desktop and Power Query for Excel, you can combine multiple data from Excel files into one big tall table. This post was contributed by Miguel Escobar and Ken Puls, Power BI experts and authors of the new ebook, “[M]agic Tricks for Data Wizards”.

Tech Tip Thursday: a look at the new Power BI Embedded Sample

Microsoft’s Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. On Thursdays we highlight a different helpful video from his collection. This week, he takes a look at the new Power BI Embedded Sample that’s designed to show you what the API code should look like from a JavaScript perspective. The new sample includes code examples and comments to give you a feel for embedding Power BI reports into your own application.

Milliman chooses Power BI Embedded for their Integrate application

Today, we’re excited to share how Milliman, a global market-leader in actuarial-products and services, has integrated Power BI Embedded into its solutions. Saptarshi Mukherjee, Senior Product Marketing Manager of Microsoft Power BI, met up with Paul Maher, Principal and Chief Technology Officer of the Life Technology Solutions Practice at Milliman, to welcome him and talk more about their solutions.

Announcing the Sales Management Solution Template for Dynamics 365 with Data Export

Back in May, we announced the sales management solution template that simplified and accelerated building powerful and compelling Power BI solutions on Dynamics CRM (now Dynamics 365). The sales management solution template offered a very fast guided experience to create compelling reports on an extensible, scalable, and secure architecture that could be customized however one needed. This meant that instead of spending one’s time on plumbing, one could instead spend it on extending and customizing the solution template to meet your organization’s needs. Today, I’m pleased to announce the integration of Dynamics CRM Data Export with the sales management solution template for Dynamics 365.