Join Gini von Courter for an in-depth discussion in this video Publishing to the Power BI service, part of Learning Microsoft Power BI Desktop.
- [Voiceover] If you want to allow other users to interact with the reports and the data sets that you have created, you'll want to publish them to the Power BI service. The URL for that is app.powerbi.com, so go out to your favorite browser, and enter app.powerbi.com. Now, if you're not logged in to whatever account you created Power BI from, you'll be prompted to do that, but most of us are already logged in to Office 365 or something else.
This is what Power BI looks like. You have access here to all of your Office 365 apps, SharePoint and so on, and you have a tutorial. You have the ability to load content packs created for your organization or services, and to import or connect to data. That's where we want to focus, because with files it says bring in your reports, workbooks, or data, so I'm going to click Get, and I have choices; one drive for business, one drive personal, I have each, I have SharePoint, but I want a local file that I've saved, one of the PBX files.
Specifically, I'm going to upload the one that we created in our last movie. I'll be asked to navigate and find that file. I believe I left it in Chapter Four, CatRequestMap.pbix, and it is being uploaded. This is the navigation pane for my work space here on the left. I have settings here, the ability to download, get access to help, search, and so on.
If you're familiar with Office 365, you'll be familiar with the icons on the top bar there. We don't need to wait to watch this spin. It won't take that long. Says this could take a while, but this is really fairly quick. Says your data set is ready, I can view my data set, but I'd like you first to see what was created on the left. We have a data set. I also have reports, and I have a dashboard, and that's the PBIX file, so if I click that file, what you'll see is that the report that I created is right here.
I can go directly to the report. I can go to the dashboard, and if I have multiple pages, I can work the separate pages, and then I can go back to my data sets, so if I want to view my data set and make any modifications. I can continue my work right here. I can create additional visuals. I have the ability to save the report, to print a current page of the report. I have the ability to change the view on the report to include text boxes and so on, more visualizations to duplicate this page and to create another page of reports if I wish.
This is how this works. While taking a deep dive into the Power BI service is beyond the scope of this particular course, I'm sure you can find your way around here if you wish. Once you have data, you can actually get more data in exactly the same way. You click Get Data, and you will come back to this same page where you can bring in more files. If I wanted, then, to bring in, for example, our data set with our countries and populations, that's another local file I have.
There's my Countries Pop Report. That's the last version of that. Again, very easy to be able to upload my data so that I have my reports and my data sets here in Power BI Service at app.powerbi.com.
- Installing and launching Power BI Desktop
- Connecting to Excel and CSV files
- Connecting to a database or web data
- Querying data
- Transforming data
- Creating relationship between tables
- Merging data
- Creating visualizations and reports
- Publishing to the Power BI service
- Sharing and unsharing reports