Selecting a dataset and storage

Selecting a shared dataset and storage mode

A data set is a grouping of data. In the case of tabular data, a data set refers to one or more database tables, each column of which represents a specific variable and each row of which corresponds to a specific record of the data set in question.

Share a dataset:

To distribute a dataset,

1. Choose Share from the data hub page or the data details page as follows:

•  Datacenter: Click the Share icon in the data items list. Choose Share from the      More options menu on a suggested data item tile.
• Click the Share icon in the action bar at the top of the page to access the dataset information page.

2. In the Share dataset window that appears, enter the names or email addresses of the individuals or organizations (distribution groups or security groups) to whom you want to grant access, then select the categories of access you want to grant. You can notify them via email that they have been granted access.             

A) Allow recipients to share this dataset: This option allows recipients to share their access with other people.

B) Allow recipients to create content using the data from this dataset: This option gives recipients build permission on the dataset, allowing them to create new reports and dashboards based on the data linked to it.

C) If you uncheck this option, the user will only have read-only access to the dataset. They can browse the dataset on its information page with read-only authorization, but they cannot create new content based on it.

D) When this option is chosen, the recipients will receive an email informing them that they have been granted access to the dataset. An optional message can be included in the email message.

3. Click the “Grant access” button. Monitor, adjust, or remove user access to your dataset by going to Manage dataset access rights.

How To Choose an Appropriate Query Type

Power BI Desktop query overview

You can connect to the world of data with Power BI Desktop, generate engaging and fundamental reports, and share your efforts with others, who can then build on your work and grow their business intelligence efforts.

There are three perspectives in Power BI Desktop:

1. Report view: where you utilize queries you write to create stunning visualizations that can be organized as you like and have several pages that you can share with others.
2. Examine your report’s data in data model format, where you may add measurements, create new columns, and manage connections.
3. Relationships view: obtain a graphical representation of the relationships defined in your data model and manage or amend them as needed.

• Select one of the three icons on the left side of the Power BI Desktop to access these views. The report view is selected by the yellow ring beside the symbol in the accompanying image. 
• A Power Query Editor is also included with Power BI Desktop. Connect to one or more data sources with the Power Query Editor, shape and change the data to match your needs, and then load that model into Power BI Desktop.

Editor for Power Query

1. To open the Power Query Editor, go to the Home tab of Power BI Desktop and select Transform Data.
2. The Power Query Editor displays as a blank window, ready for data when there are no data connections.
3. The Power Query Editor window becomes more fascinating after a query is loaded. When we connect to the following web data source, Power Query Editor loads data information, which you can then shape.

When a data connection is established, the Power Query Editor looks like this:

1. Many of the ribbon buttons have become active, allowing you to interact with the query’s results.
2. Queries are listed in the left pane and may be selected, viewed, and shaped.
3. The data from the specified query is shown and ready for shaping in the middle pane.
4. The Query Settings window appears, displaying the query’s settings and executed steps.

A query can be a request for data from your database, a request for action on the data, or a combination of the two. A query can be used to answer a simple question, calculate data from multiple tables, and add, modify, or delete data from a database, among other things.