This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. In our specific case, a customer wanted to pull data from a record that was listed in the table output of a SharePoint list.
The Windows Dev Center content pack for Power BI provides a quick and convenient way to monitor day-to-day updates to your apps’ analytics data without having to log into your Dev Center account, and gives you a rich set of visuals and filters you can customize to discover new insights. The Windows Dev Center content pack for Power BI provides analytics data for app and IAP acquisitions, ratings, reviews, and health data, for all your apps.
The 2016 Microsoft Data Insights Summit has come to a close, but not before another full day of interesting livestreamed panels! Most of the presentations will be available within the next day on the…
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.
On January 7, 2016, we launched the Best Report Contest and asked our users to submit their best Power BI report. Now it’s up to YOU to pick the winner!
Insightly is a powerful CRM and project management service that allows you to manage your business more efficiently. The Insightly content pack for Power BI offers greater understanding of your CRM…
We’re excited to announce that we’re making available a Technical Preview of Power BI reports in SQL Server Reporting Services. We plan to release the preview on Thursday along with some more info, but in the meantime, here are a couple of key things to know.
It’s time again to recap the major features and announcements we made in the Power BI service and mobile for the month of July.
Take our survey to help us continue to improve copy vs. export related scenarios in Power BI.
New gateway management features on Admin center
Back in May we held one of our most popular webinars ever: a live Dashboard Makeover to review, revise, and improve entries from our Community. This month, we’re doing it again! Ask the experts at Microsoft and find out if the visual design of your work is helping to project your data story, or just creating confusion. Attend the live webinar on October 13, 2016 to see how our Power BI pros turn dashboards and reports from standard to shiny, sharing insights more efficiently and making a bigger impact on your audience.
The September Power BI Desktop update is out now and packed with many new features and improvements! We are excited to announce our Esri map integration, DirectQuery support for the Snowflake Connector, new forecasting features, and the ability to create a mobile report layout.
We are constantly using feedback from the community to improve Power BI Desktop. This helps us understand how we’re doing and what we can do to make your experience even better. Once a quarter, we run a survey to get insight into your level of satisfaction with Power BI and to get feedback on how to make the Desktop experience even better. This is a great chance to provide direct feedback to the product team and help shape future releases of Power BI Desktop. In addition, you’ll have the chance to win some prizes.
We’re excited to share the Power BI Mobile update for June because it’s packed with really great improvements and a number of exciting new features!
In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering, the filter context is propagated to a second related table on the other side of a table relationship. Learn more in our new whitepaper.
On May 31, Paul Turley, Mentor for SolidQ and a Most Valuable Professional (MVP) for the Microsoft Data Platform, presented a Power BI Community Webinar on “Best DAX Practices From the Field”. If you’re just starting to learn DAX, check out Paul’s four recommended practices for new users!
Power BI Q&A enables users to ask natural language questions and get answer in the form of visuals or reports automatically created with the data that best answers their question. Join us for…
We are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow templates to help you easily connect to common data sources mapped against the common data model.
Dozens of Power BI visuals come out-of-the box with Power BI Desktop. These visuals are available in the visualizations’ pane when you create or edit Power BI content. These visuals are just the beginning of the available options to help you tell your data story. Learn about the variety of options you get with Power BI visuals and how to manage them in your organization.
Can’t make it to Microsoft Business Applications Summit this year? Don’t worry, we’ve got you covered – catch the opening keynote live from Atlanta, Georgia June 10 at 8:30 a.m. EDT.
Today we’re announcing the SAP Accounts Receivable solution template. The SAP Accounts Receivable solution template provides an end to end solution that contains AR data and reports sourced from your SAP system. This template includes four reports designed for a financial comptroller or other similar financial manager that needs to constantly be aware of their AR situation and provides powerful insights into accounts receivable by customer, document, and age.
Do you use DirectQuery to connect directly to your data with Power BI Desktop? If so, we’d like to hear from you!
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 revisits how to perform an IT Admin takeover for your Power BI tenant, including tenants created through individual signup. Discover the 3 main steps to performing the takeover, cost-free, using Office 365.
Announcing: The Power BI app for Microsoft Teams is now available in the US Government Community cloud
We’re excited to announce the Power BI app for Microsoft Teams is available in the US Government Community clouds (GCC). This enables organizations in GCC to use Power BI as a data hub, enables users to find data without context switches, and to bring data into more collaboration to help make better decisions.
Are you interested in shaping the future of AI in Power BI? Going to be at Microsoft Ignite in 2 weeks? We invite you to join the Power BI AI team for a brainstorming session about AI in Power BI…