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.
