Microsoft's update last month for Power BI Desktop brought new default themes, performance improvements for multi-dimensional and DirectQuery models, and plenty more. Later in the same month, the tech giant released a new version for Power BI on-premises data gateway, bringing it more in line with the changes introduced to the desktop version.
PowerBI SmartPivot is an Excel add-in that offers several new features, namely the ability to connect Power BI (Desktop and Online) and OLAP data cubes to it, perform granular searches in all data content, filter a PivotTable by a list of pasted or written values (instead of. This application requires a qualifying Microsoft 365 subscription. Microsoft 365 includes premium Word, Excel, and PowerPoint apps, 1 TB cloud storage in OneDrive, advanced security, and more, all in one convenient subscription. With Microsoft 365, you get features as soon as they are released ensur. As a regular user of Power BI on Apple device, I chosed to configure a Windows VM with parallels desktop on my machine to get the best of the two worlds: Power BI Online on Mac for reading, editing and sharing dashboard, and Power BI Desktop on my VM for advanced editing and ETL stuffs. Thank you, The Power BI team 2. Regarding the multi select: The user can do multi select in the app. By default it is disabled, he/she needs to go to the options menu and disable “single selection” mode. After disabling this it will do multi select by default (without holding the “ctrl” key) and allow the user to multi select in the app.
Now, Microsoft has unveiled a feature summary for the October update to Power BI Desktop. The highlights this month include automatic page refreshing for DirectQuery, a complete Q&A revamp, general availability for some new connectors, and the introduction of Query Diagnostics. There are also a bunch of other updates having to do with new visuals, a new file format, and performance improvements.
The complete list of new features below offers an overview of all that is new this month:
- Reporting
- Automatic page refresh for DirectQuery (preview)
- Analytics
- The new Q&A visual
- Improved user experience for Q&A
- Improved drop-down control
- Red/Blue underlines
- Improved visual results
- Natural Language improvements for Q&A
- Integration with office/Bing thesaurus
- Support for measure tables & better handling of table names and ambiguity
- Row label and synonyms support inside Modelling pane
- Q&A tooling (Preview)
- Review questions
- Teach Q&A
- Review all changes made
- Support for SSAS and Azure AS including RLS
- Visualizations
- PowerApps visual is now included by default
- New xViz visuals
- Hierarchical Variance Table
- Linear Gauge
- Tag Cloud
- Data connectivity
- Sagra Emigo connector generally available
- Azure Cost Management connector updated
- New Workplace Analytics connector
- Data Preparation
- Query diagnostics
- Data profiling enhancements
- Template Apps
- Project Web App
- Other
- New file format: .pbids
- Performance improvements for modeling operations
For those interested in checking out some of the major new features in a bit more detail, the video below has been provided:
Microsoft has also continued its tradition of recommending recently released template apps, a process that began with the August update for the desktop variant of the service. Last month, the featured one was 'Google Analytics report'. This month, the Power BI team has highlighted Microsoft's own 'Project Web App' which focuses on the visualization of reports. Built using the Project Web App data connector, the report model particularly targets project, portfolio, and resource managers. It contains 13 report pages for this purpose, supporting various management needs. You can download the template app here, and install it directly in the Power BI service, setting its parameters to your PWA website URL.
As far as performance improvements to Power BI Desktop are concerned, the Analysis Service engine has been enhanced to speed up modeling operations - which include the adding of measures, creating of relationship operations, and more -, as long as certain conditions are met. Up to 20x performance improvements have been noted during testing, though of course, the actual improvements may significantly vary based on the type of model and operations being performed.
You can download the latest version of Power BI Desktop here, and vote for more features you would like to see for the desktop variant of the data analytics service here.
-->- If you have other questions, try asking the Power BI Community.
- Still have an issue? Visit the Power BI support page.
What is the Microsoft Power BI service?
The Power BI service is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of cloud-based and on-premises data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life. Read more about Power BI.
What is a Power BI consumers?
The way you interact with Power BI will depend on your job role. As an end user or consumer, you are the person who receives content (dashboards, reports, and apps) from colleagues. You work in the online or mobile version of Power BI, which is called the Power BI service, reviewing and interacting with this content, to make business decisions. Read more about Power BI for consumers.
What's the difference between Power BI Pro and Power BI Premium?
Power BI Pro is an individual user license that allows access to all content and capabilities in the Power BI service. You can even share content and collaborate with other Pro users. Only Pro users can publish content to workspaces, share dashboards, and subscribe to dashboards and reports.
Power BI Premium provides dedicated capacity to deliver more consistent performance. It also supports larger data volumes in Power BI. For individual users, Premium enables widespread distribution of content by Pro users and it doesn't require per-user Pro licenses for recipients viewing the content. This means that consumers can collaborate with colleagues and view and interact with dashboards, reports, and apps that have been shared with them.
To learn more, see What type of license do I have?.
What if I have questions about Power BI Premium?
For questions related to Power BI Premium, see Power BI Premium FAQ.
What is Power BI Desktop?
Power BI Desktop is a free application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service. Data scientists, report designers, admins, and developers work with Power BI Desktop to produce reports and make them available to the Power BI service consumers, like you. Read more about What is Power BI Desktop.
What do I need to use the Power BI service as a consumer?
If your company has purchased Power BI licenses or a Premium capacity account, all you'll need is a Web browser and credentials. To log in, you'll use your work email address and a password (set by your Power BI administrator).
You can also sign up for the Power BI service as an individual. See the Power BI self-service sign-up process
Why do I have to sign up with my work email?
Power BI doesn't support email addresses provided by consumer email services or telecommunications providers. Learn more about the Power BI self-service sign-up process.
Does Power BI support mobile devices?
Yes. Power BI has native apps for Android phones and tablets, iOS devices, and Windows 10 devices. Download one of the Power BI mobile apps from its respective store:
What do I need to install to use Power BI?
To use the Power BI service for free, you just need a Web browser and email.
You can download the Power BI mobile apps from their respective stores, also for free:
Where do I get started with Power BI?
The following resources are available to help get you started:
- Getting started videos on our YouTube Channel
- Get started with Power BI as a consumer article
- Join our community and ask questions
- See 10 tips for getting help for more suggestions
What browsers does Power BI support?
Here's a complete list of supported browsers for Power BI.
What regions and languages does Power BI support?
Here's a complete list of regions and languages supported by Power BI.
Where can I learn more about security?
Learn more about Power BI security, privacy, and compliance here:
Power Bi Desktop Mac Install
- This Power BI Security white paper
- This Power BI security support article
How do I undo in Power BI?
Like many other Microsoft services and software, Power BI provides an easy way to undo your last command.
- To undo your last action, or last few actions, press CTRL+Z.
Power Bi Desktop App For Mac Free
Next steps
Power Bi For Mac
- More questions? Try asking the Power BI Community
- Still have an issue? Visit the Power BI support page