In this article, we take a introductory drive of power bi data sources and along with that we also have a glance that how we pull the data from sources.
Let’s Taste It !
Topics Covered
- How to load windows access file and database
- How to Json data file
- How to load a entire folder into power bi
How to Load Windows Access and Database File
Here’s, are the steps to loading access and database file.
- Open your power bi desktop app and exit the splash screen.
- Click on the “Get Data” button on your home ribbon.
- From the menu generated, Click on “More”. This will generate another list of options.
- From the options generated click “Database”.
- From the type of database listed select “Access”.
- After selecting access, Click on “Connect” located at the bottom right corner to generate the windows open dialog box.
- On the windows open dialog box, locate the access file on your system. When you find the file, Click on it and press “OK” .
- The navigator dialog box will automatically generate all the tables and queries present in the file, Click the check box beside the datasets you want to upload. When you are done, Click “Load” to differentiate b/w the types of data the navigator dialog box uses two symbols.
- A Table
- Two windows on top of each other
- The data represents access tables while the windows represent access queries.
How to Load JSON Data File
- Click on “Get Data” button on the home ribbon, this will generate a get data dialog box.
- Select “JSON” among the options given.
- Click “Connect” to leave the dialog box.
- This will transfer directly into query editor. In the query editor, the file will appear as a list of records and on top of the file, there will be list of tools transform ribbon. On the ribbon, Click the button named as “To Table”. This will generate a two table dialog box.
- Below the options listed in two tables dialog box, there are two buttons “OK” and “Cancel”. Click on the ok button to convert the list in the .Json file to tables. This dialog box will close.
- Back in the query editor, the list of records will change to column of records. Beside the column header, a button will appear. The button has a symbol directions. Click on the button.
- The .JSON will then appear as a standard datasets with the columns named appropriately and containing the right data. A .Json cannot be uploaded directly into power bi without editing it in the query editor. If you uploaded it directly, you won’t be able to access your data and any analysis you perform will give false results.
How to Load an Entire Folder into Power BI
- Once you are sure, you have the right file, Click “OK”. The contents of the file will be displayed in the navigator box.
- Click edit to save the files to query editor, load to take the files directly to power bi and “Cancel” to stop the entire process. Now there is another options that makes importing folder different from others. Click “Combine” to join all the individual files into one. This is the reason why the files had to be the same format and its contents has to have the same structure.
- If you click on “Combine” button, it will generate a pop-up menu. On the menu, click “Combine and Load”. This will generate the combine files dialog box, In the box, Select the sample file to be used to order the combination of the files.
- Click “OK” to start the combination process, once it is done, the combined file will be loaded into power bi desktop.
- Click “OK” to start the combination process, once it is done, the combined file will be loaded into power bi desktop.
- The file in the folder have to be of the same type. This means that if you want to upload a hundred files present in a folder, the hundreds files can either be excel or XML, not XML and excel. If the folder contains more than one type of formats, the importing process may not be success.
- The data in the files have to be arranged in a similar format.
- All the files have to be in a single folder, you can not upload more than one folder at once.
- Open a new power bi file, to do that, click on the “File” tab on the ribbon and select “New” a blank file will be created.
- You must know the drill by now, click on “Get Data” after that select your data folder from your local system and than close the dialog box by clicking connect.
- After connect, the folder dialog box will be generated. As you can see, it is different from the windows open dialog box. In the folder dialog box, click on “Browse” to find your file. When you find your file, click on it and you will be directed back to the folder dialog box.
Conclusion
When we as a team running any sort of business in current challenging market
so as a better business person we need to choose a best business intelligence tool that help us to shape out our business constraints and also figure out the problems that comes up after the intervention of humans so Power BI comes up with a different stance and through power bi we play with our raw data and explore it from every corner.
If you liked it, show your love by clapping and responding. Follow us for more articles.
