How to create and publish a Power BI Desktop file

0 votes
How to create and publish a Power BI Desktop file?
Nov 18, 2020 in Power BI by Roshni
• 10,520 points
827 views

1 answer to this question.

0 votes

Use the following procedure to create a basic Power BI report using the AdventureWorksDW sample database. Publish the report to the Power BI service, so that you get a dataset in Power BI, which you can then configure and refresh in subsequent steps.

  1. In Power BI Desktop, on the Home tab, select Get Data > SQL Server.

  2. In the SQL Server database dialog box, enter the Server and Database (optional) names, make sure the Data Connectivity mode is Import, and then select OK.

  3. Verify your credentials, then select Connect.

  4. If an Encryption Support dialog box appears, select OK.

  5. In the Navigator dialog box, select the DimProduct table, then select Load.

  6. In the Power BI Desktop Report view, in the Visualizations pane, select the Stacked column chart.

  7. With the column chart selected in the report canvas, in the Fields pane select the EnglishProductName and ListPrice fields.

  8. Drag the EndDate onto Report level filters and under Basic filtering select only the checkbox for (Blank).

  9. Save the report with the name "AdventureWorksProducts.pbix".

  10. On the Home tab select Publish > My Workspace > Select. Sign in to the Power BI service if you're asked to do so.

  11. On the Success screen, select Open 'AdventureWorksProducts.pbix' in Power BI.

answered Nov 18, 2020 by Gitika
• 65,890 points

Related Questions In Power BI

+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,620 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,350 points
1,922 views
0 votes
1 answer

How to create a relative data slicer in Power BI?

Hi, With the relative date slicer or filter, you ...READ MORE

answered Jan 31, 2020 in Power BI by Shivani
1,909 views
0 votes
1 answer

How to create a new slicer to filter data by district manager in Power BI?

Follow the steps Open power bi  desktop nd ...READ MORE

answered Oct 10, 2023 in Power BI by Monika kale
934 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,271 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
78,777 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
19,126 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,380 points
837 views
0 votes
1 answer

How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,890 points
1,047 views
0 votes
1 answer

How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,890 points
1,038 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP