Forum Discussion

riazahmedshaik's avatar
riazahmedshaik
Frequent Visitor
2 years ago

Dynamic M query Parameters for viewers only

Hi ,

I created a report based on Dynamic M parameters on date. From the services ,the date slicer is working for who has PBI license and giving error for who has no license. I used direct query to get the date list and converted that to text. I binded the list to date parameter. Below is the error the users facing. The workspace is premium and gave viewer access to the users. Any help is appriciated.

 

Thanks,

 

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi riazahmedshaik 

     

    Can you confirm that the user who has been granted access does have access to the underlying data source?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi riazahmedshaik ,

    The error message you provided indicates a problem with the column named "t2. Date" in the current context. Specifically, it states, "The column 't2.Date' either does not exist or is not related to any table available in the current context.

    Maybe the data in column t2 is not allowed to be accessed by non-licensees ,Then you can try to assign a free license to user 

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.