Unfortunately, Published Data Sources don't allow us to "impersonate" in Desktop. So, you'll have to publish with the "True" setting, then test in Server. Pain in the rear. More info at link above.
Thanks for the tip!
I did test in server and got the same result.
Then something else is likely wrong with the user filter. I thought the issue was that you couldn't test the User Filtering in Desktop, which I agree is a huge limitation for published data sources.
Take a look at the link shared above, and see if it helps. I'm not sure what else I can provide without seeing how you've implemented the User Filtering.
This does help.
If I need to append or otherwise edit the user filter table to which this data source (local copy) points,
will this involve a lengthy process?
In the end, I'm looking for a simple way to do the following:
1. After appending or editing tables in MS Access, refresh an extract/data source connected to/joining those tables.
2. Refresh the workbooks which point to that extract/data source.
I have been struggling for days trying to publish and refresh extracts with no luck.
I don't have any experience with this specific approach, so can't really comment on your questions.
Have you spoken with email@example.com?
Otherwise, perhaps someone else with experience can comment on your specific questions.