1. IT-Security >
  2. Programmierung >
  3. Connect Azure Data Explorer to Power BI for visual depiction of data


ArabicEnglishFrenchGermanGreekItalianJapaneseKoreanPersianPolishPortugueseRussianSpanishTurkishVietnamese

Connect Azure Data Explorer to Power BI for visual depiction of data

RSS Kategorie Pfeil Programmierung vom | Quelle: azure.microsoft.com Direktlink öffnen

Do you want to analyze vast amounts of data, create Power BI dashboards and reports to help you visualize your data, and share insights across your organization? Azure Data Explorer (ADX), a lightning-fast indexing and querying service helps you build near real-time and complex analytics solutions for vast amounts of data. ADX can connect to Power BI, a business analytics solution that lets you visualize your data and share the results across your organization. The various methods of connection to Power BI allow for interactive analysis of organizational data such as tracking and presentation of trends.

Simple and intuitive native connector

The native connector to Power BI unlocks the power of Azure Data Explorer in only a minute. In a very intuitive process, add your cluster name and let the connector take care of the rest. Provide the database and table name to focus your analysis on specific data. You can use import mode for snappy interaction with the data or direct query mode for filtering large datasets and near real-time updates. To use the native connector method read our documentation, “Quickstart: Visualize data using the Azure Data Explorer connector for Power BI.”

Imported query

A specific Azure Data Explorer query can also be used to import data to Power BI. When copying a query from Kusto Explorer or Kusto Web UI, paste it in the blank query connector window and load the query’s data to Power BI. To use the imported query method read our documentation, “Quickstart: Visualize data using a query imported into Power BI.”

General purpose SQL (MS-TDS) connector

If you prefer running SQL queries to analyze your data, use the Azure SQL Database connector to connect to Azure Data Explorer. You can use the import mode or direct query mode to bring just the data needed for analysis. To use the SQL connector read our documentation, “Quickstart: Visualize data using the Azure Data Explorer connector for Power BI.”

Example

The following example depicts how the native Power BI connector is used to query GitHub public data that was pulled into the Demo11 ADX cluster and stored in the GitHub database.

screenshot of Power BI being used to query GitHub public data

Once loaded to Power BI, you can build any report or dashboard to analyze and visually represent the GitHub event data.

Example of Power BI built report representing GitHub event data

Next steps

In this blog, we depict the various ways to query data from Azure Data Explorer to Power BI. Additional connectors and plugins to analytics tools and services will be added in the weeks to come. Stay tuned for more updates.

To find out more about Azure Data Explorer you can:

...

Webseite öffnen Komplette Webseite öffnen

Newsbewertung

Kommentiere zu Connect Azure Data Explorer to Power BI for visual depiction of data






Ähnliche Beiträge

  • 1. Azure.Source – Volume 61 vom 1640.46 Punkte ic_school_black_18dp
    Microsoft Connect(); 2018 On Tuesday, December 4th, Microsoft Connect(); 2018 provided a full day of developer-focused content—including updates on Azure and Visual Studio, keynotes, demos, and real-time coding with experts. Scott Guthrie’s keyno
  • 2. Azure.Source – Volume 58 vom 1384.54 Punkte ic_school_black_18dp
    Now in preview Update 18.11 for Azure Sphere in public preview This is an update to the Azure Sphere Operating System, Azure Sphere Security Service, and Visual Studio development environment. This release includes substantial investments in our se
  • 3. Azure.Source – Volume 62 vom 1173.34 Punkte ic_school_black_18dp
    KubeCon North America 2018 KubeCon North America 2018: Serverless Kubernetes and community led innovation! Brendan Burns, Distinguished Engineer in Microsoft Azure and co-founder of the Kubernetes project, provides a welcome to KubeCon North America 2018, which took p
  • 4. Azure.Source – Volume 60 vom 1032.54 Punkte ic_school_black_18dp
    Now in preview Simplifying security for serverless and web apps with Azure Functions and App Service New security features for Azure App Service and Azure Functions reduce the amount of code you need to work with identities and secrets under management. Key Vault re
  • 5. Azure.Source – Volume 63 vom 1004.26 Punkte ic_school_black_18dp
    Now in preview Transparent Data Encryption (TDE) with customer managed keys for Managed Instance Announces the public preview of Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) support for Microsoft Azure SQL Database Managed Instance. Azure SQL Database M
  • 6. Azure.Source – Volume 63 vom 1004.26 Punkte ic_school_black_18dp
    Now in preview Transparent Data Encryption (TDE) with customer managed keys for Managed Instance Announces the public preview of Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) support for Microsoft Azure SQL Database Managed Instance. Azure SQL Database M
  • 7. Azure Marketplace new offers – Volume 26 vom 694.91 Punkte ic_school_black_18dp
    We continue to expand the Azure Marketplace ecosystem. During September and October, 149 new consulting offers successfully met the onboarding criteria and went live. See details of the new offers below: Consulting Services   1-Day Big Da
  • 8. Azure Marketplace new offers – Volume 26 vom 694.91 Punkte ic_school_black_18dp
    We continue to expand the Azure Marketplace ecosystem. During September and October, 149 new consulting offers successfully met the onboarding criteria and went live. See details of the new offers below: Consulting Services   1-Day Big Da
  • 9. Azure.Source – Volume 59 vom 668.26 Punkte ic_school_black_18dp
    Now in preview Simplifying confidential computing: Azure IoT Edge security with enclaves – Public preview Azure IoT Edge is a fully managed service that delivers cloud intelligence locally by deploying Azure AI, Azure services, and custom logic d
  • 10. Microsoft Azure portal May 2019 update vom 660.54 Punkte ic_school_black_18dp
    This month is packed with updates on the Azure portal, including enhancements to the user experience, resource configuration, management tools and more. Sign in to the Azure portal now and see for yourself everything that’s new. Download the Azu
  • 11. Microsoft Azure portal May 2019 update vom 660.54 Punkte ic_school_black_18dp
    This month is packed with updates on the Azure portal, including enhancements to the user experience, resource configuration, management tools and more. Sign in to the Azure portal now and see for yourself everything that’s new. Download the Azu
  • 12. Azure Stack IaaS – part ten vom 624.4 Punkte ic_school_black_18dp
    This blog is co-authored by Andrew Westgarth, Senior Program Manager, Azure Stack  Journey to PaaS One of the best things about running your VMs in Azure or Azure Stack is you can begin to modernize around your virtual machines (VMs) by taking adv