Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. Uncategorized

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:

Related blog posts

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

Blog's featured image

Fabric Eventhouse now supports Eventstream Derived Streams in Direct Ingestion mode (Preview)
June 17, 2025 by Akshay Dixit

The Eventstreams artifact in the Microsoft Fabric Real-Time Intelligence experience lets you bring real-time events into Fabric, transform them, and then route them to various destinations such as Eventhouse, without writing any code (no-code). You can ingest data from an Eventstream to Eventhouse seamlessly either from Eventstream artifact or Eventhouse Get Data Wizard. This capability … Continue reading “Fabric Eventhouse now supports Eventstream Derived Streams in Direct Ingestion mode (Preview)”

Read more
Blog's featured image

Secure Your Data from Day One: Best Practices for Success with Purview Data Loss Prevention (DLP) Policies in Microsoft Fabric
June 5, 2025 by Yael Biss

As data volume and complexity soar, protecting sensitive information has become non-negotiable. With the latest enhancements to Purview Data Loss Prevention (DLP) Policies in Microsoft Fabric, organizations now have the power to proactively secure their data in Onelake. Whether you’re just getting started or looking to take your data governance to the next level, following … Continue reading “Secure Your Data from Day One: Best Practices for Success with Purview Data Loss Prevention (DLP) Policies in Microsoft Fabric”

Read more