Excel Data Refresh Query

[danielwo]

Hi all,

I have an Excel file on Sharepoint and I use PowerBi Service to GetData and then build report, however I got the follow 2 data refresh queries whenever I do editing on Excel

1. Originally I have a tab called "Exec" in the Excel file, after importing to PowerBI Service it becomes a table called "Exec", that is all great. However,  now I need to rename tab name from "Exec" in Excel to something else say "Case". I found the corresponding table on PowerBI Servie would not be renamed and all previously created visual report no longer work. Until I rename it back to original name, then everything works again. 

Question is how can I make change on Excel tab name so it will take the same effect to the table in PowerBI service??

2. When I modify the structure of a table in Excel, say adding or removing table columes, the change in the corresponding table in PowerBI doesnt take effect immediately even I refresh the dataset immediately. Seems I need to wait for several hours then the changes would take effect in the PowerBI table.

Question: How can I make the change immeidately?

Thanks.   

[v-chuncz-msft · Accepted solution]

@danielwo,

Press F5 to refresh the page, but the table and column name used in visualizations of your reports will not automatically change.