Voer je gegevens in om je te abonneren op het Microsoft Fabric-blog.

Bedankt voor je abonnement op het Microsoft Fabric-blog. Je ontvangt e-mailmeldingen wanneer we nieuwe berichten publiceren.

Microsoft Fabric Updates Blog

  1. Updates
  2. All

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:

Gerelateerde blogberichten

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

Uitgelichte afbeelding van blog

Advance your career in Data & AI with Microsoft Fabric Data Days
november 5, 2025 door Pam Spier

There’s no AI without data. Are you ready to invest in your future? Fabric Data Days offers 50+ days of immersive learning designed for data professionals at every level and students alike. Don’t miss your chance to gain practical experience, earn free certifications exam voucher, and connect with a global community of experts. Here’s what … Continue reading “Advance your career in Data & AI with Microsoft Fabric Data Days”

Meer informatie
Uitgelichte afbeelding van blog

Creator Improvements in the Data Agent
november 4, 2025 door Misha Desai

We’re introducing a set of new enhancements for Data Agent creators — designed to make it easier to debug, improve, and express your agent’s logic. Whether you’re tuning example queries, refining instructions, or validating performance, these updates make it faster to iterate and deliver high-quality experiences to your users. New Debugging Tools View referenced example … Continue reading “Creator Improvements in the Data Agent”

Meer informatie