cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Razorbx13
Helper V
Helper V

Excel Refresh

So I create an Excel workbook with an attached dataset, save the workbook in Onedrive for Business and uploaded the workbook.  Why cannot you "refresh" the workbook or work with the pivot table in Excel online via PowerBI?  How can I get around this and build a basic workbook for people to use in Excel Online (connected to the dataset)?  If this is not possible, if they save the Workbook will they be able to refresh?  

 

4 REPLIES 4
v-gizhi-msft
Community Support
Community Support

Hi,

 

According to your description, you should using Getting Data function on Power BI Service to get the workbook from OneDrive for Business rather than from the local.

20.PNG

21.PNG

If one file is uploaded from OneDrive for Business, any changes on the file from OneDrive for Business will be synchronized with the file on Power Bi Service.

22.PNG

Hope this can help.

 

Best Regards,

Giotto Zhi

Yes, but when you are in the service, go to workbooks, click a workbook and see it opens in excel online.....you cannot do anything.  You cannot filter, modify the pivot table, pull in another field from the PowerBI dataset you built it on, or just refresh.  What good is that?

Hi,

 

You can edit your workbook in Excel:

100.jpg

Or you can choose 'Import' when get data from OneDrive for Business.

36.PNG

And then use analyze in Excel function.

See this: https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#get-started-with-analyze-in-excel 

 

Best Regards,

Giotto Zhi

I cannot edit or refresh in PowerBI as I always get the following message:  

 

2020-03-12_6-08-19.jpg

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.