Direct Query & Paramters

Hi,

I have a dashboard that will be embedded into my company website, users will login to the website and an ID will be passed to the dashboard using microsoft API to filter the data accordingly. I originally tried with my data called through Import Mode, however since refreshing the dataset is asynchonous and I will have multiple users accessing at once this is not possible.

I then tried using Direct Query however I can't seem to call a stored proc and pass a parameter through, is this possible? If not are there any workarounds?

Thanks