In February we passed 300 connectors -- including the new SAP ERP connector. Since then, we've added 15 new connectors from many different partners. Moreover, you can use Azure AD authentication for ...

We recently added support for Active Directory authentication in the SQL Server connector. This has been one of the most requested feedback from our customers. In this post, I want to give an overview ...

Como transformar dados do Azure SQL utilizando Power Query do Power Automate Nesse vídeo iremos conhecer como transformar os dados em formato JSON existente no Banco de Dados SQL do Azure utilizando o ...

My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ...

I explained the options for getting the SQL generated in DirectQuery mode and why it’s so complicated in a presentation here, but I’ve recently found a new way of doing this in Power BI Desktop (but ...

Google's Microsoft SQL 2017 Server connector for its cloud-based platform makes it easier to bring data from Microsoft SQL databases into Google Data Studio.

With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we have an option to avoid this limit!