New Experience in Query to Power BI from Kusto Explorer/ Kusto web explorer

Posted by

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Query to Power BI/Excel from KE/KWE

 

Both Kusto explorer and Kusto web explorer, include an option to use a query as a basis to a Power BI report.

Until recently the feature copied text to the Clipboard and this text could be pasted into a blank query.

Already in Kusto Explorer (KE) and soon in Kusto Web Explorer (KWE) , we are changing the way the query can be used in Power BI (And in Excel)

You will find the feature in the same place and use it the same way in KE

DanyHoter_0-1667974710148.png

 

 

Or KWE (coming soon)

 

DanyHoter_1-1667974710153.png

 

 

The new experience is how you use the content of the clipboard.

In Power BI

 

Enter transform data and paste the copied query

DanyHoter_2-1667974710154.png

 

 

The query will appear and refresh

By default the query will be in Direct Query mode and yo9u can change it to import mode

 

DanyHoter_6-1667974913448.png

 

In Excel

 

The same query can also be added to Excel.

Use Data/Queries & Connections

 

DanyHoter_3-1667974710154.png

 

 

The queries pane opens

DanyHoter_4-1667974710155.png

 

 

Paste the query.

In both Excel and Power BI, you may be prompted for credentials

 

DanyHoter_5-1667974710156.png

 

 

The query will show and run in Excel.

Excel does not support Direct Query, so the data will be imported.

You need to limit the results to the row limit of Excel.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.