Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

sampor

Getting Data from MS Access 2016 database

Submitted by on ‎07-15-2019 11:04 PM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎07-16-2019 06:50 PM

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 

sampor
New Member
‎07-17-2019 04:45 PM

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.

v-qiuyu-msft
Community Support
Community Support
‎07-18-2019 01:56 AM

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

Idea Statuses