Insira suas informações para assinar o Blog do Microsoft Fabric.

Agradecemos por assinar o Blog do Microsoft Fabric Você receberá notificações por email quando publicarmos novas postagens.

Microsoft Fabric Updates Blog

  1. Atualizações
  2. Sukhwant kaur

Fabric SQL Database Integration: Unlocking New Possibilities with Power BI desktop

Introducing Seamless Connectivity for Enhanced Data Analytics and Reporting.

We are thrilled to announce a new SQL database integration with Power BI Desktop! This innovative feature is designed to empower users with streamlined access to their SQL databases, providing greater flexibility and precision for building insightful reports and dashboards.

With this integration, users can now harness the robust capabilities of Power BI to connect directly to Fabric SQL databases. Whether you’re analyzing large-scale datasets or crafting tailored visualizations, the process has never been easier. Here’s how to get started:

Learn more about Creating a SQL database in Fabric.

Note: To learn more about using Power BI desktop click Tour the Power BI report editor.

  1. Open Power BI desktop.
  2. Verify if the feature is Enable.
    1. Click File -> Options and Settings-> Options->Preview features.
    2. Make sure ‘Connect to Fabric SQL database’ option is checked.

There are 2 ways to connect to the Fabric SQL database from Power BI desktop.

OneLake Catalog

  1. On Home Tab, Click OneLake Catalog drop down and select SQL database.
  2. Select the database and hit Connect.
  3. In Navigator option select the tables for the report and hit load.
  4. Chose Import or DirectQuery.
  5. Now you are ready to Create the desired Report.

Get data

  1. On Home Tab, Click Get data > More > select Microsoft Fabric
  2. Select SQL database and hit Connect.
  3. Select the SQL database from the OneLake catalog and hit Connect.
  4. In Navigator option select the tables for the report and hit load.
  5. Chose Import or DirectQuery.
  6. Now you are ready to Create the desired Report.

Create Report

  1. Drag and drop the data into the report page.
  2. Copilot is another option to create reports easily.
  • Select Copilot from Home Tab
  • Copilot presents some reporting suggestions. Select Suggest content for a new report page.
  • Review the selections by expanding their cards. Select Create on any and all suggestions that look interesting. A new tab is created at the bottom for each.
  • You now have a Power BI report of your SQL database data. Review the reports for accuracy and make any desired modifications.

Ready to learn more?

Unlock a realm of new possibilities for your organization in the era of AI with the integration of Microsoft Fabric and Azure AI. Explore the potential, innovate, and thrive in the new digital landscape.

 If you want to learn more about these tools, consider:

Postagens relacionadas em blogs

Fabric SQL Database Integration: Unlocking New Possibilities with Power BI desktop

Imagem em destaque do blog

Announcing Staging for Mirroring for Google BigQuery (Preview)
dezembro 4, 2025 de Michaela Isaacs

Introducing staging support for Mirroring for Google BigQuery (Preview), a major enhancement that dramatically improves the speed and efficiency of initial data replication from Google BigQuery into Microsoft Fabric. Why Staging Matters Previously, initial replication of large datasets from BigQuery into Fabric could be time-consuming. With staging enabled, organizations are now seeing performance improvements of … Continue reading “Announcing Staging for Mirroring for Google BigQuery (Preview)”

Leia mais
Imagem em destaque do blog

Bridging the Gap: Automate Warehouse & SQL Endpoint Deployment in Microsoft Fabric
dezembro 3, 2025 de Pradeep Srikakolapu

Deployment Challenges While Solutions Are in Development Microsoft Fabric has revolutionized data analytics with its unified platform, but deploying complex architectures with cross-dependencies remains a significant challenge for organizations. The good news is that the Microsoft Fabric team is actively working on native warehouse deployment capabilities with DacFx, cross-item dependency resolution, and cross-warehouse reference support. … Continue reading “Bridging the Gap: Automate Warehouse & SQL Endpoint Deployment in Microsoft Fabric”

Leia mais