Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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
@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