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”.
» 深入了解 With Power BI Pro, you’ve learned how to shape data into a unified view in less time and with less effort, so you can deliver valuable business insight to decision makers when they need it. You don’t have to stop there. Microsoft CEO Satya Nadella talks about using data to change business culture so that, he says, “every organization, every team and every individual is empowered to do great things because of the data at their fingertips.” Now might be the right time for you to use the enhanced functionality in Power BI Pro to become a business intelligence hero—and help build a data culture in your organization.
» 深入了解 With this month’s release of Power BI publisher for Excel, we’ve improved the experience of connecting to Power BI data from Excel, allowing you to connect to data in read-only groups and connect to reports and datasets that were shared with you.
» 深入了解 The July update of Power BI publisher for Excel adds the ability to connect to data in Power BI and analyze it in Excel using Pivot tables and charts.
» 深入了解 We have heard your feedback and we are pleased to announce that you can now upload files to Power BI up to 1 GB in size. We also have several more improvements to our RLS and Analyze in Excel previews and a brand new feature: Favorite Dashboards.
» 深入了解 Today we are excited to announce a major improvement to Excel reports in Power BI: Uploading a complete Excel workbook from everywhere, including local files on your PC or on other storage service.
» 深入了解 We are very pleased to announce that Power BI has integrated with Azure ExpressRoute. This means that companies using Power BI will be able to use ExpressRoute to establish a private, managed connection to Power BI. Additionally, we already have an update to the RLS preview we announced in our last blog post, and a small update to video tiles on the dashboard.
» 深入了解 We’ve had an exciting few days last week during the Microsoft Data Insights Summit! Hopefully you were able to attend in person or watch some of the sessions online. Throughout the conference we announced a number of big features that everyone has been asking for, and hopefully gave you a few great surprises as well. If you missed some of the news or are looking for more details, read on to learn about all of the great features that we announced during the conference and a few other small features we released since our last update as well.
» 深入了解 Power BI publisher for Excel enables you to take snapshots of important PivotTables, Charts, cell ranges, and more from across all of your spreadsheets to a dashboard, then share the dashboard with your colleagues.
» 深入了解 If business data matters to you, here’s where to dig in deep — and at no cost.
» 深入了解