Create a first report with Power Bi Desktop using Excel sample Dataset, let’s see with an example, Topics covered here as below:-
- Save Power Bi Report file with appropriate name?
- Import Excel data to Power Bi Desktop?
- Rename Power Bi Dataset?
- Use visualization in Power Bi Report page?
- Rename Power Bi Report page?
Download & install the Power Bi Desktop setup.
Download Power Bi desktop setup from Microsoft official site, URL as below:
After Install, Double click on Power Bi Desktop Icon & You will see some Basic details screen with some fields like, name, email, etc, just cancel that screen.
And behind this you will see empty power Bi Report page. Below image for your reference.
Topic 1 : Save Power Bi Report file with appropriate name
Go to Power Bi Header Menu “File” Tab, then click to “Save“, then give file name & click on Save button.
Power Bi Report file extension is .PBIX, don’t change this extension.
Topic 2: Import Excel Dataset to Power BI Desktop
- Learn in detail :- Get data from Excel to Power Bi
- Download Sample Dataset: Excel Sample Dataset for practice
Go to Header menu , click to Get Data and select Excel Datasource.
After that select your excel file and click on Load button.
Topic 3: Rename Power Bi Dataset
Earlier Field section was empty, after import Excel dataset all fields display under Fields section, from here you can change Dataset name.
Right click on Dataset, then click on Rename.
Topic 4: How to use Visualization in Power Bi?
Click on Visualization Pane, there is more then 24 default visuals. Select Table visual to display data.
Double click on Table visual & Drag columns from fields section to Values.
Next to Values section, there is Format Icon, using this you can change the Font size, font color, height, width of Table visual.
Topic 5: Rename Report Page in Power Bi
Right click on Default Page Name, there is many options like Rename Page, Duplicate Page, Hide Page & Delete Page.
you can add new Report page to click on Plus Icon button.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.