Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need to pass a custom UserId in via javascript and out via datasource api URL

I’m not sure if this is possible. I’m quite new to Power BI, have done a lot of research on the forums and on Stack Overflow, but am still not sure if what I want is possible.   We have a current r...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    As far as I know, I'm afraid we can't pass something like UserId here through the Embedded URL. Actually, it won't work even if we can do it. Because we just interact with the dataset and report in Power BI Service. We don't interact with the data source directly. We can't trigger a dataset refresh when embedding. (It's the Import mode we are talking here). 

     

     

    Best Regards,

    Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This might work for us, though our use case is far more complex than the example shown. We'll still need to build the dataset for each user on our end before passing it back to the report.

     

    The CustomData and User Identity mentioned, can we access this and attach it to our api URL in the Advanced Editor?

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous,

       

      1. The CustomData feature will only work for models that reside in Azure Analysis Services, and it only works in live mode. Please refer to embedded-row-level-security#working-with-analysis-services-live-connections.

      2. Do you mean "Advanced Editor" is the one in the Desktop? 

      3. It's parameters that we use in Power BI to get data. Please refer to deep-dive-into-query-parameters-and-power-bi-templates/.

       

      I think we need RLS in your scenario rather than parameters. 

       

      Best Regards,

      Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        We have 1,000s of users. Each user has a different view of the data. That view is not based on simple access to columns or rows of data.

         

        For example: some of the data we display is accumulated totals based on 100s of different pieces of data. For each user, the 100s of pieces of data that go into building the totals will be different. Accumulating these totals is not a simple addition process, it factors in many other calculations.

         

        This is why I think the only way to do this is for us to build the dataset for a user dynamically via our own api, returning a unique json result set for each user.

         

        RLS looks far too simple for what we require.

         

        The Advanced Editor I was referring to was in the Desktop UI, where datasources are configured. We’d like to send back the UserId as part of the datasource url. Ex: https://myapi/datasource?userId= 121345

         

        My key question is if we can attach the UserId I pass in as part of the datasource url as above.