Power BI functions

[轉分享] 

~A look at Visual Data Prep in Power BI dataflows~

 

In this week's tip of week, we are going to talk about the Visual Dataprep public preview feature for data flows. The Diagram View in Power Query reimagines self-service data prep and provides an interface to easily prepare and transform your data and visualize the data preparation process.

 

This feature can be enabled by selecting 'Diagram View' within the View tab in the ribbon. Diagram View provides you a visual interface to create, view, or modify your queries. You can just click the expand/collapse button to expand or collapse a query that you want to see. Also, with step level actions, you can edit step level settings, rename a step, delete a step, and more from the context of the query steps.

 

Check out this video from Guy in a Cube to get more detail about Diagram View in Power Query.

Video link: https://www.youtube.com/watch?v=h9r0BOTQxmQ&feature=emb_logo

 

Power BI blog post - Announcing Visual Data Prep public preview (Diagram View in Power Query): https://powerbi.microsoft.com/en-us/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/

======================================

To format the column containing the URLs as "Data Category" --> URL.

 

Refer to the doc below:

1. In Data view or Report view, select the column containing the URLs
2. On the Modeling tab, select Data Category > Web URL.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables