Dynamic M Parameter an SQL Server

Ive got a feedback from microsoft regarding this topic.

"at this time the feature is still in preview, and we intend on bringing in additional connector support, though we do not have any timelines in which we can share publicly as of yet. I would continue to monitor the release notes or Power BI blog for updates as Yana has shared.

There are no workarounds for today to enable the SQL Server databases for this particular feature – but if a real-time response and parameter based action is needed I may suggest looking at the use of a Paginated Report or using the Paginated Report visual on a Power BI Report page as these could be some alternative solutions available for use today"

We will try to solve this requirement by a diffrent way (maybe split the data). 

Or we try this workaround: https://www.youtube.com/watch?v=3QiTBXfxzHA

Cheers 

Alex