已贴标签的帖子:Excel

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".

» 阅读更多内容

What it takes to become a business intelligence hero

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.

» 阅读更多内容

Power BI Service March Update Part 2

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.

» 阅读更多内容