In this post, we take a look at How to Import Excel Data into the Power BI Service. let's say you are into the office and holding the yearly data of variety of the sales and the expenses. Those are kind of accumulating and also learning to be scattered for specific records.
And if you want to import them into the Power BI desktop or the cloud service, you have to learn to first get them into the application, run the DAX queries and also learn how to make use of them for the import and the analysis operations.
So let's learn how to do just that.
First thing that we would be doing is getting the datasets or the data for our example. So we need variety of the excel files if we can get hands on. And another thing is we may be in need of the files that we can use as part of the power bi desktop import. So you can use the excel file here.
Next thing is you can follow the video above on the process of how to get the data inside the power BI and what it needs in terms of the variable to show the chart on the screen. If you can see that it would be reasonable for you to view the excel data on the power bi service too. So you should follow that video as well.
In theory we only deal with the local files when we make use of the excel import option. However there are sources of the data that we have on the cloud these days. Like say excel file in the office 365 or so. And that we use for the editing and importing the content. So that kind of works out.
In such case you make use of the Excel file in the URL format. And that would be a good deal for you to work with the data that you have there. You have to think of the means for the importing the excel data into the power BI desktop. Once that is published and the data goes to the cloud everything just works from there.
Power BI is a good tool for the data visualization. I already covered the initial setup post and also covered the CSV import post. I thought why not go ahead and work with the excel import option. So that would be a good thing for you to check out as well. In that context I would say you should use the current post to add up more knowledge for you.
