Forum Discussion
Resolver IIDynamic M query parameters checkbox not showing in Options
I eventually got to the bottom of this. There were 2 issues here:
1- This functionality only works with DirectQuery sources. If you're just wanting to pick a complicated Excel file from a SharePoint folder of identically laid out Excel/CSV files you can't do it.
2- If you are using a DirectQuery then this feature became "generally available" in the April 2022. Once this happens it no longer appears under File>Options and Settings>Options>Preview Features. This is the reason I couldn't even see the check box, which threw me off the scent (hence why I thought it might be down to our set-up).
Resolver III eventually got to the bottom of this. There were 2 issues here:
1- This functionality only works with DirectQuery sources. If you're just wanting to pick a complicated Excel file from a SharePoint folder of identically laid out Excel/CSV files you can't do it.
2- If you are using a DirectQuery then this feature became "generally available" in the April 2022. Once this happens it no longer appears under File>Options and Settings>Options>Preview Features. This is the reason I couldn't even see the check box, which threw me off the scent (hence why I thought it might be down to our set-up).