MariaDB Certified For Power BI
Tuesday, 22 December 2020

MariaDB has announced that the MariaDB Direct Query Adapter has been certified for Microsoft Power BI. The tool enables Microsoft Power BI Desktop users to connect to, query, model and visualize their data without downloading the complete data set locally.

MariaDB began life as an alternative to MySQL when Oracle took over the original MySQL. Microsoft Power BI is a tool that lets you analyze and interact with big data, working within Excel.

mariadb

The MariaDB Direct Query Adapter for Power BI supports data stored in MariaDB on prem and in the cloud on MariaDB SkySQL. The adapter is Microsoft certified and available as a menu option from within Power BI. 

Until now, users of Power BI had to download the data locally, meaning they were restricted to 1 gigabyte of data from the databases because of the limitations in memory on the physical system operating Power BI. The new adapter makes it possible to use Power BI on much larger databases in the terabytes and petabytes ranges. As a part of Microsoft’s list of certified connectors, the MariaDB Direct Query Adapter now appears as an option within Power BI.

directquery sqlserverdb

There are some limitations to using DirectQuery. The queries can't be too complex or the adapter throws an error, and the query editor doesn't work with multi-dimensional sources like SAP Business Warehouse. You also can't create queries that use 'time intelligence' features such as querying a date column for a year, quarter, month, or day.  There's also a one-million-row limit for cloud sources, with on-premises sources limited to a defined payload of about 4 MB per row  or 16MB data size for the entire visual. The limit doesn't affect aggregations or calculations used to create the dataset returned using DirectQuery. It only affects the rows returned.

mariadb 

More Information

MariaDB Site

Related Articles

MariaDB 10.4 Reaches Release Candidate Status

MariaDB Announces New Enterprise Server

MariaDB Adds Node.js Connector

Mapbox Visual for Microsoft Power BI Upgrades Visualizations

SandDance Added To PowerBI

Microsoft Launches Self-Service BI

Power BI

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner

DuckDB And Hydra Partner To Get DuckDB Into PostgreSQL
11/11/2024

The offspring of that partnership is pg_duckdb, an extension that embeds the DuckDB engine into the PostgreSQL database, allowing it to handle analytical workloads.


+ Full Story
pg_parquet - Postgres To Parquet Interoperability
28/11/2024

pg_parquet is a new extension by Crunchy Data that allows a PostgreSQL instance to work with Parquet files. With pg_duckdb, pg_analytics and pg_mooncake all of which can access Parquet files, is  [ ... ]


+ Full Story
More News

espbook

 

Comments




or email your comment to: comments@i-programmer.info
Last Updated ( Tuesday, 22 December 2020 )