Power BI Service Dataset Connect to Power BI Desktop

This Features Allow you to connect datasets in the Power BI service to Power BI Desktop. This feature allows you to create new reports off existing datasets you’ve already published to the Power BI web

To get started with this feature, you’ll first need to enable the preview option in Power BI Desktop. Navigate to File > Options and settings > Options > Preview features and enable Power BI Service Live Connection. You’ll need to restart Desktop in order for the option to take effect.

From Get Data – we can get Power BI service Option

From there, you will get a list of your workspaces. Expand each workspace to see the list of datasets you can use to create reports.

Push Datasets To Power BI Streaming Datasets By Microsoft Flow

 

We can use Power BI streaming datasets to easily build real-time dashboards by pushing data into the REST API endpoint, and having that data update in seconds on their streaming visuals

For Creating Streaming Datasets

First Of all Go To Power BI Web and click on Streaming Datasets option .

From there, we will create a dataset of type API

We Can Name the dataset as we want but necessary to remember Then, add the following fields to the streaming dataset

For Twitter We can Create data with time (DateTime), tweet (Text) , sentiment(Number)

Now For Create a Flow which will push Tweets and their sentiments to Power BI. Go To https://flow.microsoft.com/en-us/

Sign in, and then go to “My Flows”, then “Create from blank.”

Now, go to Twitter category, and select the “When a new tweet is posted” and Use Power BI for Search term .It will start a Flow whenever a tweet which contains the search term is posted.

We will pipe these Tweets into the Microsoft Cognitive Services Sentiment Detection Flow action to understand the positivity of the Tweet content. This action takes in a Tweet, and outputs a number from negative to positive.

Select “New Step,” then “Add an action,” then search for “Sentiment Analysis” and select the “Cognitive Services Text Analytics – Detect Sentiment” action For That We Need  API Key

Entered API key and Information in it and pipe in the Tweet text to the sentiment detection action by selecting it from the dynamic content pane on the right side of the screen. Flow should now look like the following

Now go to “New step,” then “Add an action,” and then enter “Power BI” into the search box. Select “Add row to streaming dataset” from the actions list

Select the name of the workspace, then the name of the streaming dataset in the first step, and select the Table titled “RealTimeData.” Note that all streaming datasets created in powerbi.com will have one table named “RealTimeData.”

Create a dashboard with a streaming visual in Power BI. Go To  Power BI Web , go to a dashboard, select “Add tile,” then “Custom streaming data” and finally the name of the streaming dataset that we created in the first step.

Dashboard is Look Like

 

Power Bi Report View Updates

Drop down slicer – Power Bi adding adding more types of slicers to reports. The drop down slicer. This Slicer is use full for when we have lots of data to locate.

In Slicer Custom Visual We Can make it Drop down Box

We can See Data like below

Hierarchical axis – Hierarchy With in this Visual, in a Drill down Option of Visual We Can Get Detail View of Hierarchical axis. And Better Understanding of particular field Details.

We Can Use hierarchical labels by turning off the label concatenation experience in the formatting pane.

Matrix conditional formatting –  In matrix We Can Turn On Conditional formatting by opening the field well menu for the measure and selecting Conditional formatting.

By Conditional Formatting We can make Different between Lowest Middle and Highest Value by Giving Colour.

Its Look Like..

Axis label and title colour control – By it we can now format  axis title colour  also separately from the axis labels.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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