Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Press F5 to refresh the page, but the table and column name used in visualizations of your reports will not automatically change.
Press F5 to refresh the page, but the table and column name used in visualizations of your reports will not automatically change.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.