Forum Discussion
Refreshing MS Access in Power BI
I have a very basic MS Access database with one table saved on my machine and I am able to import the table into Power BI. However, when I add new data to the MS access DB, and then hit 'refresh data' in Power BI, none of the new data is uploaded into Power BI. Is this not possible with Access and Power BI? And if not, are there other workarounds that I could possibly implement instead?
Thank you.
wfarrell,
Do you click Refresh button in Data/Report view of Power BI Desktop or query editor? If you disable "Include in report refresh" option for your table in query editor and click refresh button in report view of Power BI Desktop, the data will not get updated in Data/Report view of Power BI Desktop.
Regards,
Lydia
1 Reply
wfarrell,
Do you click Refresh button in Data/Report view of Power BI Desktop or query editor? If you disable "Include in report refresh" option for your table in query editor and click refresh button in report view of Power BI Desktop, the data will not get updated in Data/Report view of Power BI Desktop.
Regards,
Lydia