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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

nerd2000

Filter Field from Access Data Base Source DataFormat.Error

Submitted by Advocate I on ‎03-15-2018 12:48 PM

I connected to a table in access.  Appeared to load fine.  I then filtered the query on a text field - but the initial display of labels to choose from was only one as the records that had other values were beyond the preview, so I hit load more and then selected the value I wanted to filter - and it returned this error:

 

DataFormat.Error: No value given for one or more required parameters.
Details:
    TCM.accdb

 

It appears to filter fine if you select a value from the initial list based on the preview records and breaks after you select a value from Load more.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎03-19-2018 01:14 AM

Hi @nerd2000,

 

Please share detail steps with some screenshots for us to test it on our side. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses