Power BI platform adds new data prep, mobile capabilities – TechTarget

Getty Images/iStockphoto
New data preparation and mobile analytics capabilities highlight Microsoft’s most recent additions to the Power BI platform.
The tech giant delivers new features to Power BI on a weekly basis, and each month releases a blog post summarizing all the tools being added to the platform throughout the month.
Posted on Feb. 17, the February summary includes more than 40 new capabilities.
Among them, Dynamic M Query Parameters to support SQL Server has the potential to be particularly useful to Power BI platform users, according to Doug Henschen, an analyst at Constellation Research.
Dynamic M Query Parameters is a data preparation tool that enables Power BI users to specify the parameters of a query without having to write code.
When first released, however, it only enabled connections to M-based data sources, which are data sources provided directly by Microsoft or those that were accessible through DirectQuery, such as Amazon Redshift, Snowflake and Google BigQuery.
Now in preview, Dynamic M Query Parameters is able to access new data sources through DirectQuery, including SQL-based Microsoft data sources such as SQL Server, Azure SQL Database and Azure Synapse Analytics, as well as non-Microsoft data sources such as Oracle, Teradata and the SAP HANA relational database.
Henschen called the extension of Dynamic M Query Parameters to support SQL Server and other data sources that Power BI did not previously support “an update of note.”
“It was obviously important for Microsoft to support its own products, including SQL Server, Azure SQL Database and Azure Synapse Analytics, as well as Oracle, Teradata and SAP HANA,” he continued.
In addition, new mobile formatting options are important additions to the Power BI platform, according to Henschen. Also in preview, users can format visuals for their mobile layout and have those formatting changes affect only their mobile view rather than desktop or web views as well.
“The new mobile formatting options are important and overdue,” Henschen said, noting that leading analytics platforms enable users to author reports, dashboards and other assets once and deliver them in various forms.
But getting those analytics assets to work in all forms — particularly mobile — can be tricky, so adding easy-to-use formatting options for mobile viewing will be useful.
“It’s tough to get [the view] right for all form factors, so Microsoft has added mobile formatting options to better optimize the mobile viewing experience without compromising the desktop version of the same asset,” Henschen said. “This will help report authors avoid kludgy workarounds and redundant versions of assets to best serve desktop and mobile experiences.”
In addition to the new capabilities developed by the Power BI team, the tech giant added tools developed by Lumel Technologies, a Microsoft partner, to the Power BI platform in February.
Lumel is a startup founded in 2021 and based in Plano, Texas, that custom-builds BI and analytics products for its customers.
Using Power BI’s SDK and API framework, Lumel developed Inforiver, an end-to-end analytics and performance management platform for Power BI that comes packaged as an importable custom visual.
Among the capabilities Inforiver includes that are now available as part of the Power BI platform are forecasting and simulations for planning, paginated reports, export of tabular reports to Excel, PDF generation and a complete audit log of changes to aid with governing self-service users.
The addition of Inforiver’s capabilities to Power BI is significant for two reasons, according to Donald Farmer, founder and principal of TreeHive Strategy.
“First, the existence of a powerful and complementary third-party application validates the Power BI SDK/API strategy,” he said. “Without an excellent SDK and comprehensive APIs, the integration would not be possible. Second, Inforiver offers really good no-code implementation of features Power BI users have been clamoring for.”
Farmer, who helped lead Microsoft’s BI team during a 10-year period before leaving for Qlik and then starting his own consulting firm, noted that the capabilities added through Lumel’s Inforiver are some Microsoft might have had difficulty building for Power BI.
“With Inforiver, Lumel has taken Power BI in a direction Microsoft themselves would struggle to achieve,” he said. “There’s a quality, consistency and above all an agility [with Inforiver] that has caught the attention of the community.”
Beyond the new data preparation and mobile capabilities in preview, other new tools for the Power BI platform unveiled in February include:
“There are many incremental improvements in this update, but the sheer number of updates add up to some notable improvements around key themes,” Henschen said.
He noted that the three data label features give organizations better control over sensitive information, while the additions to Goals demonstrate that Microsoft is responding to early feedback.
“There are also a slew of data connector and data visualization updates that are incremental individually, but they add up to real progress,” Henschen said.
But while Microsoft continues to add new functionality to Power BI, and the tech giant’s commitment to the platform ensures that it is among the most complete analytics suites, it remains lacking in one key area, according to Henschen: Power BI does not match many of its competitors in its support for clouds other than its own Microsoft Azure.
Vendors such as MicroStrategy, Qlik and Tibco that aren’t owned by cloud giants are cloud agnostic. And even Looker and Tableau, once independent but now subsidiaries of Google and Salesforce, respectively, support multiple clouds.
Power BI, however, lacks that neutrality, according to Henschen.
“The most obvious gap for Power BI compared to independents is multi-cloud support,” he said. “Power BI can certainly tap into data sources on premises or on any cloud, but I have yet to hear anything about using Power BI services anywhere but on Azure.”
The vendor looks to integrate an edge-to-cloud database architecture with a new release that provides developers with tools to …
CEO and co-founder Josh Patterson outlines the promise of the new language-agnostic data analytics development framework and why …
Big data is driving changes in how organizations process, store and analyze data. The benefits are spurring even more innovation….
Think you’re ready for the AWS Certified Solutions Architect certification exam? Test your knowledge with these 12 questions, and…
Amazon said its van monitoring system is designed solely for driver safety. But many industry experts have concerns regarding the…
Amazon would like to strengthen its global footprint, but the e-commerce giant faces roadblocks and challenges today that did not…
As cord-cutters give rise to streaming services’ popularity, Salesforce and AWS partner to capitalize on each other’s strengths: …
Box expands Slack integration to become Slack’s content layer for Box users and add security for sharing documents; Dropbox joins…
With more video content than ever, many organizations have adopted video content management systems. This comparison chart …
Oracle plans to acquire Cerner in a deal valued at about $30B. The second-largest EHR vendor in the U.S. could inject new life …
The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a …
This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider …
SAP tools like SAP Business Planning and Consolidation can help companies switch from periodic closing to continuous accounting …
SAP ERP products can help users with international accounting challenges like GAAP vs. IFRS. Learn how the software can …
IBM’s new Breakthrough, a bundle of IaaS and consulting services, is aimed at giving SAP customers one-stop shopping for S/4HANA …
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered …
SQL Server databases can be moved to the Azure cloud in several different ways. Here’s what you’ll get from each of the options …
In this book excerpt, you’ll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL …
All Rights Reserved, Copyright 2010 – 2022, TechTarget

Privacy Policy
Cookie Preferences
Do Not Sell My Personal Info

source

Share:

More Posts

Market Research

Pulse Surveys

Turn feedback into action

Our survey platform makes it easy to measure and understand feedback so you can drive growth and innovation

Pulse Handshak

Pulse Handshak

Collaborative online survey tool for the market research industry. Remote assisted surveying just like face-to-face interviews. Here interviewers can talk to the respondent over the web-console without the need for any other communication channel and share the same Q're with responses and click actions.

Pulse FE

Pulse FE

Pulse Field Expert or Pulse FE is the main platform for both offline and online survey at softofficepro.com. It is robust and used by hundreds of clients over tens of years with millions of responses. Do it once Q're and deploy on both offline devices (android) and online forms makes it a great cost effective platform for any kind of responses

Pulse Ultimate

Pulse Ultimate

Pulse Ultimate is targeted for tracking studies and retail audits. An offline survey system offering extreme field control including processes like data quality check, back-check, rework, comparison with previous wave data etc. helps to get the best results on a day-to-day basis

Pulse LS

Pulse LS

Use a managed Limesurvey and our expertise for creating complex forms and token based user management. Use optional mailing system to send survey invitation to each participant and track progress of the response status. Industry standard SPSS / R output supported