Explore

F23 IN6003 Systems Analysis Lab 1: How to use Power BI Web Service to upload excel data and create an analytic dashboard on both Mac and Windows

Here is a student lab learning guide on how to use Power BI Web Service to upload excel data and create an analytic dashboard on both Mac and Windows:

Here's how you can upload an Excel file to OneDrive and then use it in Power BI:

Upload Excel file to OneDrive:

Go to the OneDrive website (onedrive.live.com) and sign in with your Microsoft account or your school/work account associated with Power BI.

Click on the "Upload" button and select the Excel file from your computer that you want to use in Power BI.

Once the upload is complete, note down the file's location in OneDrive.

⁠

Connect Power BI to OneDrive:

In Power BI, click on "Get Data" on the left-hand side menu.

Search for "OneDrive" in the search bar and select "OneDrive - Business" or "OneDrive - Personal" based on your account type.

Click "Connect" to start the connection process.

Authenticate with OneDrive:

A pop-up window will appear, asking you to sign in to your OneDrive account. Enter your credentials and click "Sign in".

Grant permission for Power BI to access your OneDrive files by clicking "Yes" on the permission prompt.

Select Excel file from OneDrive:

After authentication, you will see your OneDrive files and folders in Power BI.

Navigate to the folder where you uploaded your Excel file and select it.

Click "Load" to start importing the Excel data into Power BI.

Organize Data and Create Analytic Dashboard:

Follow steps 3 to 6 from the previous response to organize your data and create an analytic dashboard using the imported Excel data.

By uploading your Excel file to OneDrive and connecting Power BI to OneDrive, you can still utilize its features to analyze and visualize your data in Power BI Web Service.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.