Forum Discussion

Christoff's avatar
Christoff
New Member
8 years ago

Switching from Excel to Power BI

I am starting in a new position where a lot of data on many tabs is kept on a central excel sheet on the server. People access the excel sheet and update it given the prompts: What is your project, w...
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Christoff

According to your information, I learn you want to show data stored in excel files to Power BI, and make the data update timely when data in excel has been changed.

If my understanding is right, you can consider two ways.

1. import excels to Power BI Desktop, then publish reports to Power BI Service, then set schedule refresh for the excel source.

make sure the location excel is stored on the same server where Power BI Desktop and on-premises gateway run.

 Refresh a dataset created from an Excel workbook on a local drive

 

 

2.upload excel files onto OneDrive for Bussiness, then connect to files on OneDrive for Bussiness in Power BI Service directly.

When you setup a refresh schedule, Power BI will connect directly to the data sources using connection information and credentials in the dataset to query for updated data, then load the updated data into the dataset. Any visualizations in reports and dashboards based on that dataset in the Power BI service are also updated.

Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

 

Best Regards

Maggie