Supercharge BI insights with the new Azure Synapse Analytics workspace connector for Power Query

Published Nov 10 2021 09:00 AM 3,393 Views
Microsoft

Announced at Ignite 2021, data analysts can now speed up and simplify business analytics on more Azure Synapse data sources with the new Azure Synapse Analytics workspace connector for Power Query, available in public preview.

 

This new connector expands the integration between Power BI and Azure Synapse to include access to all Azure Synapse databases, including data stored in Apache Spark pools, data lakes, linked databases, and data imported by Azure Synapse Link. Analysts can also streamline their analytics with the ability to preview data, including metadata and pre-established table relationships. This means more certainty and less prep time when locating and importing data for analysis in Power BI.

 

Simplified collaboration to drive business insights

 

Data teams often face bottlenecks when provisioning data sources for end user analysis. Locating the right data, importing it to the correct business analytics tool, and knowing how to pair up tables and sources to answer business questions has historically been a clunky process requiring multiple rounds of requests. The Azure Synapse Analytics workspace connector streamlines this process, providing analysts working in Power BI direct access to the great work their data colleagues have already put into defining relationships and preparing data in Azure Synapse.

 

The new Azure Synapse Analytics workspace connector for Power Query automatically detects Azure Synapse workspaces, previews tables, and captures table relationships to empower business users to quickly find insights and to ensure consistency across data teams. This means business analysts can review Azure Synapse data sources, quickly understand the content with imported metadata and table relationships and do light code-free data prep to get the data they need without requiring a technical counterpart.

 

Limitless analytics with Azure Synapse and Power BI, now easier than ever

 

To generate meaningful insights, business analysts require reliable data sets that have been transformed, enriched, and prepared for end user analysis. Azure Synapse Analytics provides a limitless analytics platform to accomplish all of these data tasks and to support business analytics at scale, uniting the worlds of structured SQL data warehousing and big data analytics in Apache Spark to empower and connect individuals and teams at every stage of the analytics process.

 

The Azure Synapse Analytics workspace connector in action

 

To take advantage of the Azure Synapse workspace connector in public preview, you'll need access to an Azure Synapse workspace and to Power BI Desktop.

 

1. To get started, open Power BI Desktop and navigate to Get data > Azure Synapse Analytics workspace (Beta)

 

Aria_Jelinek_1-1636494652697.png

2. Locate the workspace you'd like to use > select Tables to analyze

 

Aria_Jelinek_2-1636494689471.png

 

3. Perform any additional code-free data transformations with the Power Query editor

 

Aria_Jelinek_0-1636512985819.png

 

 

4. Review and verify imported data relationships

 

Aria_Jelinek_0-1636513154840.png

 

5. Start reporting on your data in Power BI! 

 

Aria_Jelinek_2-1636512680086.png

 

What's next?

 

 

 

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2929352%22%20slang%3D%22en-US%22%3ESupercharge%20BI%20insights%20with%20the%20new%20Azure%20Synapse%20Analytics%20workspace%20connector%20for%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2929352%22%20slang%3D%22en-US%22%3E%3CP%3EAnnounced%20at%20Ignite%202021%2C%20data%20analysts%20can%20now%20speed%20up%20and%20simplify%20business%20analytics%20on%20more%20Azure%20Synapse%20data%20sources%20with%20the%20new%20Azure%20Synapse%20Analytics%20workspace%20connector%20for%20Power%20Query%2C%20available%20in%20public%20preview.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20new%20connector%20expands%20the%20integration%20between%20Power%20BI%20and%20Azure%20Synapse%20to%20include%20access%20to%20all%20Azure%20Synapse%20databases%2C%20including%20data%20stored%20in%20Apache%20Spark%20pools%2C%20data%20lakes%2C%20linked%20databases%2C%20and%20data%20imported%20by%20Azure%20Synapse%20Link.%20Analysts%20can%20also%20streamline%20their%20analytics%20with%20the%20ability%20to%20preview%20data%2C%20including%20metadata%20and%20pre-established%20table%20relationships.%20This%20means%20more%20certainty%20and%20less%20prep%20time%20when%20locating%20and%20importing%20data%20for%20analysis%20in%20Power%20BI.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3ESimplified%20collaboration%20to%20drive%20business%20insights%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EData%20teams%20often%20face%20bottlenecks%20when%20provisioning%20data%20sources%20for%20end%20user%20analysis.%20Locating%20the%20right%20data%2C%20importing%20it%20to%20the%20correct%20business%20analytics%20tool%2C%20and%20knowing%20how%20to%20pair%20up%20tables%20and%20sources%20to%20answer%20business%20questions%20has%20historically%20been%20a%20clunky%20process%20requiring%20multiple%20rounds%20of%20requests.%20The%20Azure%20Synapse%20Analytics%20workspace%20connector%20streamlines%20this%20process%2C%20providing%3C%2FFONT%3E%26nbsp%3B%3CFONT%20color%3D%22%23000000%22%3Eanalysts%20working%20in%20Power%20BI%20direct%20access%20to%20the%20great%20work%20their%20data%20colleagues%20have%20already%20put%20into%20defining%20relationships%20and%20preparing%20data%20in%20Azure%20Synapse.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20new%20Azure%20Synapse%20Analytics%20workspace%20connector%20for%20Power%20Query%20automatically%20detects%20Azure%20Synapse%20workspaces%2C%20previews%20tables%2C%20and%20captures%20table%20relationships%20to%20empower%20business%20users%20to%20quickly%20find%20insights%20and%20to%20ensure%20consistency%20across%20data%20teams.%20This%20means%20business%20analysts%20can%20review%20Azure%20Synapse%20data%20sources%2C%20quickly%20understand%20the%20content%20with%20imported%20metadata%20and%20table%20relationships%20and%20do%20light%20code-free%20data%20prep%20to%20get%20the%20data%20they%20need%20without%20requiring%20a%20technical%20counterpart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3ELimitless%20analytics%20with%20Azure%20Synapse%20and%20Power%20BI%2C%20now%20easier%20than%20ever%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20generate%20meaningful%20insights%2C%20business%20analysts%20require%20reliable%20data%20sets%20that%20have%20been%20transformed%2C%20enriched%2C%20and%20prepared%20for%20end%20user%20analysis.%20Azure%20Synapse%20Analytics%20provides%20a%20limitless%20analytics%20platform%20to%20accomplish%20all%20of%20these%20data%20tasks%20and%20to%20support%20business%20analytics%20at%20scale%2C%20uniting%20the%20worlds%20of%20structured%20SQL%20data%20warehousing%20and%20big%20data%20analytics%20in%20Apache%20Spark%20to%20empower%20and%20connect%20individuals%20and%20teams%20at%20every%20stage%20of%20the%20analytics%20process.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3EThe%20Azure%20Synapse%20Analytics%20workspace%20connector%20in%20action%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20take%20advantage%20of%20the%20Azure%20Synapse%20workspace%20connector%20in%20public%20preview%2C%20you'll%20need%20access%20to%20an%20Azure%20Synapse%20workspace%20and%20to%20Power%20BI%20Desktop.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20To%20get%20started%2C%20open%20Power%20BI%20Desktop%20and%20navigate%20to%20Get%20data%20%26gt%3B%20Azure%20Synapse%20Analytics%20workspace%20(Beta)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_1-1636494652697.png%22%20style%3D%22width%3A%20539px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325760i31BCD1F6DB2EDFDC%2Fimage-dimensions%2F539x598%3Fv%3Dv2%22%20width%3D%22539%22%20height%3D%22598%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_1-1636494652697.png%22%20alt%3D%22Aria_Jelinek_1-1636494652697.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E2.%20Locate%20the%20workspace%20you'd%20like%20to%20use%20%26gt%3B%20select%20Tables%20to%20analyze%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_2-1636494689471.png%22%20style%3D%22width%3A%20682px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325761i6310D371BB4F35C2%2Fimage-dimensions%2F682x542%3Fv%3Dv2%22%20width%3D%22682%22%20height%3D%22542%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_2-1636494689471.png%22%20alt%3D%22Aria_Jelinek_2-1636494689471.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E3.%20Perform%20any%20additional%20code-free%20data%20transformations%20with%20the%20Power%20Query%20editor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_0-1636512985819.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325873i0E42AEB5CC4271D5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_0-1636512985819.png%22%20alt%3D%22Aria_Jelinek_0-1636512985819.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E4.%20Review%20and%20verify%20imported%20data%20relationships%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_0-1636513154840.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325874i3E1C808FCC043DC4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_0-1636513154840.png%22%20alt%3D%22Aria_Jelinek_0-1636513154840.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E5.%20Start%20reporting%20on%20your%20data%20in%20Power%20BI!%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_2-1636512680086.png%22%20style%3D%22width%3A%20883px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325872i43B62062EBA0EC1E%2Fimage-dimensions%2F883x443%3Fv%3Dv2%22%20width%3D%22883%22%20height%3D%22443%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_2-1636512680086.png%22%20alt%3D%22Aria_Jelinek_2-1636512680086.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3EWhat's%20next%3F%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ETo%20explore%20the%20connector%20further%2C%20%3CA%20href%3D%22https%3A%2F%2Fpowerquery-staging.microsoft.com%2Fen-us%2Fblog%2F419%2Fpreview%2F%3Fpreview%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ereview%20the%20Ignite%202021%20blog%20post%3C%2FA%3E%20from%20our%20Power%20Query%20team.%3C%2FLI%3E%0A%3CLI%3ETo%20learn%20more%20about%20Azure%20Synapse%20Analytics%2C%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fsynapse-analytics%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eexplore%20our%20home%20page.%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20color%3D%22%23000000%22%3ETo%20review%20all%20of%20our%20Azure%20Synapse%20updates%20at%20Ignite%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-synapse-analytics%2Fignite-2021-announcements-accelerate-time-to-insight-with-azure%2Fba-p%2F2912147%22%20target%3D%22_blank%22%3Echeck%20out%20this%20overview%3C%2FA%3E.%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2929352%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aria_Jelinek_0-1636065472776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324407iCEDEFE575C34B712%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Aria_Jelinek_0-1636065472776.png%22%20alt%3D%22Aria_Jelinek_0-1636065472776.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20more%20about%20reporting%20on%20all%20of%20your%20Azure%20Synapse%20data%20sources%20in%20Power%20BI%20with%20the%20NEW%20workspace%20connector%2C%20now%20in%20public%20preview.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2929352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Ignite%202021%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUpdates%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Nov 10 2021 08:35 AM
Updated by: