PBI001 How to connect excel data sources with PowerBI Tool
How to connect excel data sources with PowerBI Tool. We have to check the given precondition, required test data and follow below steps with corresponding expected result.
Pre condition
One Access to a valid data source.
Two Power BI Desktop is open.
Test Data
Sample data source (e.g., Excel file).
Step One: Open Power BI Desktop. PowerBI should be open
Step Two: In Power BI Desktop,Navigate to Get Data and click on the "Get Data" button. Folders should be open to select the dataset.
Step Three: Choose a data source (e.g., Excel, CSV, SQL Server).Folder is displayed to select the Dataset.
Step Four: Provide necessary credentials or information to connect to the selected data source. Click on load the data.
Step Five: Load the data into Power BI. Dataset should be loaded
Step Six: Drag and drop a table visualization onto the canvas. From Visualization select the table option table should be displayed on the canvas
Step Seven: Add a field to the table. Dataset field is displayed on the right side, selects the field to add in the table and can also apply filters to the table.
DigiAI Solutions Private Limited
+91 - 9372225821