#Power bi desktop vs service how to#
#Power bi desktop vs service pro#

I can click the link open in Power BI to go straight to our report and open it in the browser. IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›m just going to select my workspace for now and now the reports published up to Power BI. My workspace is kind of your default scratchpad but then there are other workspaces that maybe youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›re part of groups that have these workspaces that you could publish this into as well. If this is the first time youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ve done this youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll get prompted to sign in to the Power BI service so pop in your email address you may need to authenticate here as well but youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll get presented with this list and this will show you all of the workspaces in the Power BI service. IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll get prompted to save the file locally first. So you can see in the ribbon I have the publish button. Now letР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s publish it up to the Power BI service to track this and share it with others. Now I could edit and transform this data as it gets loaded into Power BI but itР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s in pretty good shape already so IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›m just going to load it straight into Power BI desktop and youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll see over on the right-hand side all of those columns from that.Р В РІР‚СњР вЂ™Р’В®xcel table get translated into fields within Power BI and now building visuals is as simple as dragging and dropping these onto the canvas so letР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s take our for instance sales amount and drag that over, we get a little chart and letР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s break that down by the different segments. IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›m just going to choose a sample workbook when it connects youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll see itР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll pull in a preview of all of the tables and tabs in that excel workbook. YouР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll get a list of all of the data sources that Power BI supports but weР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›re just going to use excel for now. When you open up Power BI desktop for the first time youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll see the getting started screen and to begin all you need to do is hit get data over on the left-hand side. You can then use to track the data over time and share and collaborate with others around your organization.

#Power bi desktop vs service how to#

Then IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll show you how to publish that up to the Power BI service and build some dashboards from that. WeР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll start with Power BI desktop and connect us an Excel spreadsheet data, pull that in and build some visuals. LetР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s start with an overview of the whole of the Power BI product set.

#Power bi desktop vs service pro#

Power bi service free vs pro comparison Power BI Service and Power BI Desktop Build reports on top of those datasets and then you can build dashboards that pull content from all of those different reports into one place. To get started with Power BI you need to upload datasets or connect to datasets in a particular workspace. The thing is when you pin visuals from reports on to dashboards, it retains that link, so whenever I click on one of these charts or these visuals it will take me back to that underlying report. So for example, the bar chart came from one report, the donut came from a different report and the map came from a third report. So like I said any of these tiles can be pinned from this dashboard from multiple different reports. The dashboard that IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ve created has got a number of different tiles on it, IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ve got a title, IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ve got some bar charts, a donut chart and a map as well. IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›m logged into Power BI and IР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›m just looking at one dashboard in my workspace so like I said this is kind of a scratchpad area (please refer to the screenshot) where I can put all of my personal content and I can share things with other people from here but typically this is an area where youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll just work with stuff that was just for you. LetР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›s have a look at some examples of how that works. We can see how those dashboards are made up of visuals from particular reports and how those reports pull data from particular datasets. A dashboard can have several tiles in it that are extracted from various different reports yet each report is attributed to one dataset and one dataset only.

Within those workspaces youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll have a number of dashboards, youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›ll have a number of reports and a number of datasets. The one that youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›re most likely to use is my workspace which is kind of your own personal area to hold your information. Workspaces are a kind of a container that can have many different dashboards inside them.

So there are a few significant concepts to understand when youР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›re using a Power BI service and the significant things are workspaces, dashboards, reports, and datasets. It relates people to a vast variety of data via easy-to-use dashboards, powerful reports, and beautiful visualizations that bring our data to life. Power BI is a cloud-based business analytics service that allows us to conceive and interpret data with a higher rate, performance, and intelligence. The main highlights of power bi service user interface (1) navigation pane (2) canvas (3) question & answer box (4) icon buttons, including help and feedback (5) dashboard title (6) office app launcher (7) power bi home (8)Р В РІР‚в„ўР вЂ™Р’В icon buttons