文章標示:Excel

Register now for the Microsoft Business Applications Summit – July 22–24, 2018 in Seattle!

We’re excited to announce registration is open for the first-ever Microsoft Business Applications Summit, coming to Seattle July 22–24! Combining the best of the Microsoft Data Insights Summit, Convergence, and the Dynamics 365 Technical Conference, this new event is designed to help you create the best, lasting solutions for your business.

» 閱讀更多

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 April Update: ExpressRoute for Power BI

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.

» 閱讀更多