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 ,
I have created a powerbi report using excel data. When I overwrite the data with new data in the excel workbook and do a refresh in powerbi desktop, the refresh appears to work successfully- no error messages- but that data does not change- still displays the old data. Any ideas as to what could be wrong?
Solved! Go to Solution.
@avigilan,
Do you click Refresh button in Report view or Query Editor of Power BI Desktop? If you disable "Include in Report Refresh" option for your table in Query Editor and click Refresh in Report view of Power BI Desktop, data will not be changed in Power BI report.
Regards,
Lydia
I'd check:
Hi Ross,
I checked all of those things you mentioned- everything appears it should work correctly. When I load the data, there are no error messages, however when I try to view the data nothing displays-odd
@avigilan,
Do you click Refresh button in Report view or Query Editor of Power BI Desktop? If you disable "Include in Report Refresh" option for your table in Query Editor and click Refresh in Report view of Power BI Desktop, data will not be changed in Power BI report.
Regards,
Lydia
This was exactly what solved my problem. I have 60 data fields and could not explain why some were not refreshing after pressing "Refresh". Thank you!
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.