Learn how to use Azure SQL Database for BI, and how to create, connect, query, and analyze your data with various tools and services. Skip to main content LinkedIn Articles ...

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks. While the embrace of big data, machine learning, and IoT by business enterprises everywhere may ...

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

This tutorial shows you how to use Power BI to connect to SQL Data Warehouse and create a few basic visualizations. A SQL Data Warehouse pre-loaded with the AdventureWorksDW database. To provision ...

We present in this video how to get data from the Azure Data Lake resource by setting access permissions and creating a dataflow in the Power BI Service to be consumed and published in the cloud. We ...

Next I have the all-important Transform data using Power Query action. At the moment you can only use Power Query with SQL Server data sources, and (at least when I tested it) it only seems to work ...

Power BI isn’t just for business users; you can also use it to visualize data for IT monitoring tools. Power BI’s solution template for Azure Activity Logs uses an Azure SQL database and ...

Sandvik Coromant is one of the world’s leading suppliers of tools, tooling solutions, and know-how for the metal working industry. The Swedish company has extensive investments in research and ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...