![power bi desktop rs power bi desktop rs](https://i.ytimg.com/vi/0Zr5DQic3Tg/hqdefault.jpg)
Downloading analytical data sets can present challenges such as download speed and inadequate memory on a local machine, and even a powerful laptop or desktop will be outperformed by the processing power of a high end database server or MPP system. MariaDB Direct Query Adapter enables Power BI users to work with remote data without the need to download it onto the local machine. SkySQL analytical service is stored within object storage, which is highly scalable and cost-efficient, making it extremely appealing, especially compared to having to set up and maintain a separate data warehouse solution. Columnar data storage is designed to deliver real time analysis on billions of rows. Data is written to disk by column rather than row and is automatically partitioned. In the case of analytics, MariaDB uses a columnar smart engine designed to handle extremely large data sets and the ad hoc queries of analytical workloads.
![power bi desktop rs power bi desktop rs](https://docs.microsoft.com/en-us/power-bi/fundamentals/media/desktop-getting-started/designer_gsg_report1.png)
The easiest way to experience the power and versatility of MariaDB is through SkySQL.
![power bi desktop rs power bi desktop rs](https://docs.microsoft.com/en-us/power-bi/connect-data/media/desktop-report-lifecycle-datasets/report-lifecycle_01.png)
MariaDB Platform can be configured for standard transactions, analytics or both. The MariaDB Direct Query Adapter lets Power BI users leverage the MariaDB database layer directly to handle operations, increasing query performance. Power BI lets analysts connect to multiple sources of data, such as MariaDB, and create data models and shareable visual representations such as charts and graphs. Microsoft Power BI is a popular data visualization and BI tool with a global user base. The adapter is Microsoft certified and available as a menu option from within Power BI. The MariaDB Direct Query Adapter for Power BI supports data stored in MariaDB on prem and in the cloud on MariaDB SkySQL. The MariaDB Direct Query Adapter enables Microsoft Power BI Desktop users to connect to, query, model and visualize their data without downloading the complete data set locally. We are excited to announce the availability of a new Microsoft Power BI Desktop integration with MariaDB.