Faysal Easy Excel

This is the first report I'm going to prepare through Power BI Desktop. The first thing is adding raw data. To do this, you need to Click the Get Data option in Startup Screen .  Image 1: Startup Screen of Power BI Desktop If you are advanced user, then you don't need to open this startup window all the time while you need to open data sources. You can get data by Clicking on Home | Get Data | More . While the Get Data dialog box appeared, Select the Excel program and Click on Connect button: Image 2: Get Data dialog box After appearing Open dialog box, Select the Excel file which you want to open and Click on Open button. Now this will connect to your Excel file . When it is done, it will show you a Navigator dialog box listed with all data tables present in that Excel file. Select the Table or Tables which you want to open (i.e. Invoice ) and Click on Load . After Loading, it will show you Sheet Names . If you have 2 different tables in ...

Download: Power BI Desktop is a desktop application includes with Microsoft Power BI software and services, that allows you to connect your raw data and then designing require reports. You can download the Power BI Desktop application from this link . Install: After Downloading the application file from the above link, double Click on it to install it. You can install it either 32bit or 64bit whichever your system supports. Run Power BI Desktop: So once you download it, you'll install Power BI Desktop and run it like other applications on Windows  Image 1: Power BI Desktop startup screen Power BI Desktop connects to different types of data sources, from your pc to cloud. And then changing data types, working with dates. You can work with tables and build relations in between tables to get your report fast.