DEV Community

Cover image for Enterprise Power BI Series
David Abu for Microsoft Azure

Posted on • Edited on

Enterprise Power BI Series

This PowerBI Everywhere series discusses how to use Power BI to analyze data. The first video discusses how to use Azure SQL data sources with Power BI. The last video discusses how to use data governance to ensure that data is properly analyzed.

Before we delve into each series, there is a Microsoft Learn content that helps you understand the data platform, I suggest you read and practice it as it will give you a lot of contexts to what different Microsoft technologies offers, click here.

  1. The Azure SQL and Power BI: This video series discusses how Power BI and SQL Server work better together, starting with how to connect a Power BI Desktop to a SQL Server database. Christopher discusses different scaling techniques for Power BI reports, including how to scale with Azure Synapse. The presenter shows how to connect to a SQL Server database from Power BI Desktop. He also shows how to connect to a different data source, such as an e-commerce website.
    Power BI and Azure SQL Synergy

  2. Dataverse and Power BI Synergy : This video discusses the Power BI and Dataverse synergy. Two ways to integrate data from Dataverse into Power BI are discussed: direct query and import mode. Direct query is faster, but data from Dataverse cannot be cached. Import mode is more versatile but requires knowledge of Power BI's Vertapack engine. In this video, Scott Sewell introduces himself and discusses the role of a product manager on the Power BI team. He goes on to discuss how dataverse (an application built on top of Power Apps) evolved to become its own platform. He concludes the video by sharing some examples of Power BI applications that use dataverse.

Power BI and Dataverse Synergy

  1. Empower Enterprise Analytics with Composite Model in Power BI: This video series discusses how to use Power BI to analyze data. The first video discusses how to use the composite model to combine different data sources. The last video discusses how to use data governance to ensure that data is properly analyzed. In this video, Marco demonstrates how to create a power bi report from a PBX file, and how to use a semantic model to navigate and analyze the data. The user also shows how to connect to another user's power bi data set and create a report.

Empower Enterprise Analytics with Composite Model in Power BI

  1. Purview, Azure Synapse and Power BI: This video provides an overview of how to use Power BI to load and visualize data from Azure Synapse. It covers data ingestion, transformation, and visualizations. Josh discusses h ow to use Power BI to visualize data from different sources in Azure Synapse. They will be working on a demo of synapse and power bi integration. The Azure Synapse Analytics workspace provides a centralized interface for data storage and data processing, with an extensible architecture that enables integration of commonly used data stores and visualizing tools. Azure Synapse Studio is the tool used for data management and data transformation in Azure Synapse Analytics.

 Purview, Azure Synapse and Power BI

Top comments (0)