Forum Discussion

miken72's avatar
miken72
Helper I
4 years ago
Solved

Query parameters accessible by end-users of Web-published rerports?

Hello,   We have several reports that read from a very large dataset.  We are building in RLS (Row Level Security) so that a user can only see the results that they are allowed to see. That is wor...
Dataflow
General Comment
  • ibarrau's avatar
    ibarrau
    4 years ago

    I haven't seen this feature in the roadmap for a short term. So would say no. If you still want to read about it this article shows a little more: https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

    On the other hand you can handle this things using import mode. You can load both years of data and filter it in memory. Of course it depends on the amount of data and licenses, but usually I think that import mode can handle more features.

    Regards,

miken72's avatar
miken72
Helper I
4 years ago

Hello ibarrau, and thanks for your reply,

I've started looking into it and got my hopes up, but then saw that - as far as I can see - M queries only work with NoSQL M (MUMPS) datasources. From what I have just read - and I hadn't heard of M databases till about 30 minutes ago -  M databases like GT.M only run on Linux boxes. 

I like a challenge, but the project I am working on would get a somewhat more complicated if it was to involve setting up an M database,  and having regular updates of data converted and loaded from our Windows environment RDBMS to the M db so that the PowerBI reports could then read from that M db.

That said, I will ask around the company I work for - you never know...

Meanwhile, do you know if Microsoft has any plans to make a functionality similar to that of dynamic M query parameters for SQL Server?
It's their own product so you'd think it could be done - or maybe (fingers crossed) it has been implement during 2021 (since the articles I read were published)?

ibarrau's avatar
ibarrau
Super User
4 years ago

I haven't seen this feature in the roadmap for a short term. So would say no. If you still want to read about it this article shows a little more: https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

On the other hand you can handle this things using import mode. You can load both years of data and filter it in memory. Of course it depends on the amount of data and licenses, but usually I think that import mode can handle more features.

Regards,