cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Data from MS Access 2016 database

When connecting with an Access database data source using a saved query, that data is not being updated correctly.  In comparison to a table, which does get uploaded correctly.

Status: New
Comments
Moderator

Hi @sampor

 

Do you mean the data doesn't update in Power BI desktop or service? 

In Power BI desktop, you can click on Refresh button to update data in the report. In Power BI service, you need to configure the gateway for dataset then refresh dataset to get data updated in the report. 

 

Best Regards,
Qiuyun Yu 

New Member

Hi Qiuyun,

I'm updating the data in Power BI Desktop and using Refresh.  Extra data is being added into the uploaded table than the source table, for the data is originating from a query.  Tables upload correctly but the data from queries is not right.

Moderator

Hi @sampor

 

I'm not very clear about "Extra data is being added into the uploaded table than the source table, for the data is originating from a query.  Tables upload correctly but the data from queries is not right.". Would you please share some screenshots to elaborate it? 

 

Best Regards,
Qiuyun Yu