IT Brief New Zealand logo
Technology news for New Zealand's largest enterprises
Story image

AtScale launches native support for Data Analysis Expressions on Microsoft Power BI

By Shannon Williams
Tue 4 May 2021
FYI, this story is more than a year old

AtScale has announced native support for Data Analysis Expressions, a formula expression language used in Analysis Services, Microsoft Power BI, and Power Pivot in Microsoft Excel.

Native DAX support lets Power BI users connect to AtScale in live connection mode. Live connections can provide fast and seamless access to AtScales semantic layer platform, which provides a foundation for delivering and managing data access and quality across the diverse and complex data landscape in the modern cloud-first enterprise.

According to AtScale, by using AtScale, organisations can establish a semantic layer in their data infrastructures to free their data consumers from time-consuming data wrangling and preparation and to ensure consistent reporting without the need for retooling or retraining. 

"The AtScale semantic layer not only creates a single point for data access and a central governance gateway across the enterprise, but also bridges business users across data migrations," the company says.

"As organisations continue to move their enterprise data into cloud platforms, the ability for BI and data science teams to easily access live data is critical. 

"With native DAX support, AtScale makes data accessible and analytics-ready for Power BI users regardless of the physical location of raw data."

Christopher Lynch, executive chairman and CEO of AtScale, says customers are adopting Microsoft Power BI in large numbers - and they demand best-in-class integration for their users.

"With this new integration, AtScale delivers an excellent customer experience for Power BI users looking for live data access on cloud data platforms," he says.

Arun Ulagaratchagan, corporate vice president of the Business Intelligence Platform at Microsoft, adds, "The success of Microsoft Power BI in the enterprise accelerates demand for readily accessible curated business data.

"I am pleased that Power BI can now more seamlessly connect to AtScale so that our mutual customers can fully benefit from their investments into Power BI and AtScale to foster a data-driven business culture and make informed decisions."

Key features of improved AtScale connectivity in Power BI include:

Live Connection to Cloud Data Platforms 
The AtScale semantic layer platform provides live access to cloud data without compromising performance. Power BI users can use live connection mode with AtScale to access up-to-date data at full fidelity, without pre-aggregation or data engineering work. There is no need for decision makers and information workers to manage data extracts or data pipelines to enjoy the speed-of-thought performance that Power BI users demand and expect.

Curated Data Models 
Thanks to native DAX support, AtScale dimensional models can be consumed seamlessly in Power BI. These curated and governed data models can help to increase the quality of data analysis and accelerate the adoption of a data-driven business culture across an organisation. When connecting to these curated models in AtScale, Power BI users are assured that the source of their data is trustworthy, as are the steps taken to clean and improve it. Their reports produce consistent results using a single source of truth.

Impersonation & Single Sign-On (SSO)
In live connection mode, Power BI automatically passes the identity of the user opening a report to the underlying data access infrastructure. There is no need to specify separate data source credentials. With an appropriate data gateway configuration, Power BI users can connect using their preferred LDAP or Active Directory (AD) accounts. When publishing reports and dashboards to the Power BI Service, AtScales query impersonation support will ensure that the report viewer appears as themselves so that access controls can be enforced consistently at the semantic layer and its underlying data sources.

Enhanced Performance
With AtScale's native DAX support, Power BI can use the richness of its native formula expression language in exactly the same way as with Microsoft SQL Server Analysis Services. Power BI users can navigate metadata and use visualisations in their reports without requiring Power BI to translate DAX into a SQL dialect or other query language and thus avoiding associated performance impact.

Seamless Integration with Power BI 
From the Power BI perspective, AtScale provides feature parity with Microsoft SQL Server Analysis Services. This means all current and future Power BI features available in live connection mode with SQL Server Analysis Services are also supported with AtScale. There is no need to deploy additional connector components or drivers.
 

Related stories
Top stories
Story image
Amazon Web Services / AWS
Zscaler, AWS accelerate onramp to the cloud with zero trust
Zscaler has announced an extension to its relationship with Amazon Web Services, as well as innovations built on Zscaler's Zero Trust architecture.
Story image
Cybersecurity
Aqua Security, CIS create software supply chain security guide
Aqua Securityand the Center for Internet Security have together released the industry’s first formal guidelines for software supply chain security.
Story image
Cybersecurity
Threat actors ramp up their social engineering attacks
As people get better at identifying potential threats in their inbox, threat actors must evolve their methods. Their new M.O? Social engineering.
Story image
Commerce Commission
ComCom puts electronics sector on notice over resale price maintenance
The Commerce Commission has concluded an investigation into allegations that television manufacturers were engaging in illegal resale price maintenance.
Story image
Apple
Jamf updates healthcare IT to protect data on Apple devices
Jamf has rolled out new functionality to help healthcare and IT teams protect patient data and streamline clinical access for their Apple fleet.
Story image
Sustainability
Schneider Electric ups the ante on sustainability strategy
"We've made some progress but to avoid a major energy challenge, all data centres - including distributed edge data centres - must be more sustainable."
Story image
Partnerships
Microsoft expands APAC Enabler Mentorship Program
"Mentors are the key to success for every professional. A good mentor is a coach, a guide, as well as a vocal advocate."
Story image
Collaboration
IT and security team collaboration crucial to data security
Many IT and security decision makers are not collaborating as effectively as possible to address growing cyber threats.
Story image
Network Security
Netskope announces zero trust network access updates
Customers can now apply zero trust principles across a range of hybrid work security needs, including SaaS, IaaS, private applications, and endpoint devices.
Story image
B2B
Corpay partners with supply chain platform PracBiz Exchange
Corpay's new partnership with PracBiz’s allows more than 4000 B2B suppliers on the latter's platform to use Corpay's global payments services.
Story image
N4L
N4L, Spark, Chorus partner for Hyperfibre school upgrade
Networks for Learning (N4L) has partnered with Spark and Chorus to upgrade Wellington College to Hyperfibre, fostering stronger outcomes for students and teachers.
Story image
Artificial Intelligence
Salesforce harnesses automated solutions with new developments
Salesforce has launched Sales Cloud Unlimited, a new feature to help accelerate productivity with AI and automation.
Story image
Cybersecurity
Ingram Micro launches vendor-backed security program
Ingram Micro has unveiled a new program intended to give resellers the effective offerings their customers need to stay safe in the evolving threat landscape.
Story image
PagerDuty
Ready for anything with the PagerDuty Operations Cloud
In a world of digital everything, teams face increasing complexity. Ever-growing dependencies across systems and processes put customer and employee experience, not to mention revenue, at risk.
Story image
Secure access service edge / SASE
Cloudflare adds new capabilities to zero trust SASE platform
New features for Cloudflare One include email security protection, data loss prevention tools, cloud access security broker, and private network discovery.
Story image
Cybersecurity
Why is NZ lagging behind the world in cybersecurity?
A recent report by TUANZ has revealed that we are ranked 56th in the world when it comes to cybersecurity - a look into why we're so behind and what needs to be done.
Story image
Electricity
Canstar finds Flick Electric NZ’s favourite provider
Canstar’s annual research to find New Zealand’s favourite electricity provider reveals Flick Electric has come out on top.
Story image
API
Industry-first comprehensive risk-based API security enhances protection
Application Programming Interfaces (APIs) have become a crucial part of operating web and mobile application businesses and are causing significant economic growth in the digital sector.
Story image
CRM
Microsoft launches app for modern selling experience
The new release is designed to enhance CRM systems with customer engagement data from Microsoft 365 and Microsoft Teams.
Story image
Tech job moves
Tech job moves - Boomi, Limepay, Thales, VMware & Zoom
We round up all job appointments from June 6-16, 2022, in one place to keep you updated with the latest from across the tech industries.
Story image
INTERPOL
Hundreds arrested, millions seized in global INTERPOL investigation
A two-month-long investigation by INTERPOL this year involved 76 countries and clamped down on organised crime groups behind telecommunications and social engineering scams.
Story image
Contact Centre
Customer service agents don't want to return to contact centres
A new report has revealed that 85% of customer service agents want to work full-time at home and not return to contact centre offices.
Story image
Ransomware
Rapid7 report examines use of double extortion ransomware attacks
New insight into how attackers think when carrying out cyber attacks, along with further analysis of the disclosure layer of double extortion ransomware attacks, has come to light.
Story image
Citrix
The best ways to attract young talent during labour shortages
New research from Citrix reveals hybrid working and ventures into the metaverse are top of mind for Gen Z workers.
Story image
SaaS
Sealord partners with Infor to improve sustainability
Sealord has chosen Infor as a strategic partner to implement an operational cloud-based platform that provides day-one functionality and sustainability gains.
Story image
Cybersecurity
Significant security concerns resulting from open source software ubiquity
"The risk is real, and the industry must work closely together in order to move away from poor open source or software supply chain security practices."
Story image
Digital Transformation
Apptio adds portfolio enhancements to promote digital strategy
"While digitalisation creates opportunities, it also makes budgeting far more complex, leading many companies to waste substantial funds."
Story image
Testing
Video: 10 Minute IT Jams - An update from Tricentis
Tricentis provides software testing automation, and software quality assurance products for enterprise software.
Story image
SaaS
Varonis strengthens security capabilities for AWS and S3
Varonis has strengthened and expanded its cloud and security capabilities, with a critical aim of improving safety and boosting data visibility in Amazon Simple Storage Service (S3).
Story image
Infrastructure
Lenovo announces launch of Retail Solutions portfolio in A/NZ
Lenovo has announced the launch of its Lenovo Retail Solutions portfolio across the A/NZ region, which they say will help retailers transform their business and face future retail demands.
Story image
Robotic Process Automation / RPA
rapidMATION helps Coates achieve success with landmark RPA solution
A strong Robotic Process Automation solution (RPA) can help solve many complex issues that businesses face daily. 
Story image
10 Minute IT Jams
Video: 10 Minute IT Jams - An update from Rimini Street
Today we welcome back Daniel Benad, who is the GVP & regional GM for Oceania at Rimini Street.
Story image
Dark web
Cybercrime in Aotearoa: How does New Zealand law define it?
‘Cybercrime’ is a term we hear all the time, but what exactly is it, and how does New Zealand define it in legal terms?
Story image
Entelar
How TruSens air purifiers can create healthier workspaces
The pandemic has heightened our awareness of our own and others’ health, and made us all much more conscious of the environments we work in.
Story image
Cloud
Cloudflare outage in 19 data centers worldwide due to own error
Cloudflare says its outage for 19 of its data centers yesterday was because of a change in a long-running project to increase resilience in its busiest locations.
Story image
Open source
DataStax secures US$115 million to fund database expansion
DataStax has secured US$115 million in funding, which it will use to develop and expand its Astra DB multi-cloud database and Astra Streaming service globally.
Story image
Cybersecurity
Greater API usage raises concerns for protection - report
Radware has released its 2022 State of API Security report, which shows a rise in APIs, with 92% of the organisations surveyed significantly or somewhat increasing their usage.
Story image
Disaster Recovery
Eaton provides business continuity with disaster avoidance application
Many SMBs often struggle with problems relating to UPS and IT assets due to the sheer amount of time and resources required to run effectively. 
Story image
Orbital Insight
Orbital Insight solution set to drive better data-driven decisions
The company says the new Site Intelligence solution will provide granular visibility, behaviour analytics and deep insights about customers and competitors at any location. 
Story image
Shouta
The rise of digital gifting in the workplace
The name itself does most of the explaining; it’s a gift you receive virtually. But a misconception about digital gifts is that they need to be redeemed virtually as well. 
Story image
Microsoft
Volpara, Microsoft project to detect cardiovascular issues
Volpara Health Technologies is working with Microsoft on a research and development project to speed up creating a product that detects and quantifies breast arterial calcifications (BACs).
Story image
Hybrid workforce
Why hybrid working is here to stay and how to ace it
Citrix's new report reveals hybrid workers are more productive and engaged at work than their office and completely remote counterparts.
Story image
Infrastructure
VMware wins Google Cloud partner award for infrastructure modernisation
The cloud computing and virtualisation company was recognised for its achievements as part of the Google Cloud ecosystem.
Story image
eInvoicing
Airwallex, Xero extend partnership with easier invoice payments
Airwallex has extended its long-term partnership with Xero by releasing a new payment link integration for Xero invoices that will make receiving them easier and faster for Australian businesses.