Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Filter Field from Access Data Base Source DataFormat.Error

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
Comments
v-qiuyu-msft
Community Support

Hi @nerd2000,

 

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

 

Best Regards,
Qiuyun Yu