Forum Discussion

Juramirez's avatar
Juramirez
Icon for Resolver I rankResolver I
8 years ago

Get value from C# app to Power BI Embedded

Hi!   I have my Power BI Reports embedded in a C# app. This app sends by JS a parameter when you select from the home page certain value. I want to catch this value into power BI report and use it ...
Need Help
Tips and Tricks
Juramirez's avatar
Juramirez
Icon for Resolver I rankResolver I
8 years ago

Thanks v-ljerr-msft for your answer but that's what I've just donde and it works perfectly. What I want now is to get the URL value  into power BI and this way that I can execute an Stored Procedure to bring only the data that I want from SQL Server. I mean, for example, in my app I log in with a user that has as idFromURL = "USER1" and this id is right now being passed by url and is filtering all the data of all the users (because the database bring everything) by this id but if I can get this id into the moment that power bi goes to de DB and filter it by an SP (or something that just bring me the data respect that id). I expect something like this: 

Sql.Database("server", "database", [Query="EXEC sp_BringDataByUserID @User = 'idFromURL' "])

 

Hope you can help me ! :D

  • Juramirez's avatar
    Juramirez
    Icon for Resolver I rankResolver I
    8 years ago

    Thanks gilbertocrespo

     

    Let me check if it works for me! 

     

    Regards

    • Juramirez's avatar
      Juramirez
      Icon for Resolver I rankResolver I
      8 years ago

      Hi gilbertocrespo.

       

      How did you get the value from the URL? I mean, i'm passing an ID by URL but i don't know how to get this value in my advanced editor to call an StoredProcedure (SQL Server) with this ID as value for my StoredProcedure. I want something like this: 

      Sql.Database("server", "database", [Query="EXEC sp_BringDataByUserID @User = 'idFromURL' "])

       

      Regards

      • gilbertocrespo's avatar
        gilbertocrespo
        Icon for Advocate I rankAdvocate I
        8 years ago

        I guess you are focusing on Stored Procedure too much. Let the PowerBI does this service to you.

         

         

        On controller Home\HomeController.cs,  before to generate token:

         

        var generateTokenRequestParameters = new GenerateTokenRequest("View", null, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: "5", datasets: new List<string> { report.DatasetId }, roles: new List<string> { "clientid" }) });

         

        5 is my clientId

        clientid is the collumn name I created on each report

         

         

        On PowerBI Desktop:

        Enter the following DAX expression on your report:

        [clientid] = VALUE( USERNAME() )

         note: I'm using value() to converts my string into int

         

        This way your data is filtered BEFORE to bring it to PowerBi Service.