Forum Discussion

westerdaled's avatar
westerdaled
Frequent Visitor
4 years ago

Power Apps Integration with a BI Report: can we automatically pass in system values e.g. report ID

We have a requirement to embed the same Power App I am building in a number of BI reports .  Would be good if the we could also pass in metadata such as report id or report url as well as the fields we have selected . This I could pass to row in another data source.

Looks like PowerBiIntegration is limited to the fields we select only .

 

Otherwise, I think we will neeed to put some sort of  user friendly Id label on the report , make this Report Id a mandatory field in the Power App and hope the users enter the correct Id .

General Comment

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    This I could pass to row in another data source.

     

    smells like a red flag.  The formula firewall will not be happy about that.
    Also note that "external" PowerApps come with limited functionality when used in a Power BI visual. Only "internal" (ie created from within Power BI)  Apps have the full integration experience.

    • westerdaled's avatar
      westerdaled
      Frequent Visitor
      3 years ago
      lbendlin wrote:

       

       

      This I could pass to row in another data source.

       

       

       

      smells like a red flag.  The formula firewall will not be happy about that.

       

       Ah sorry it is my clumsy wording. No red flags or formula police necessary!!!!  What I am referring to is getting the user to capture details regarding the report such as the report url .  After validation, I simply pass the values to my data source via a flow hooked up to a stored procedure . Just testing this now. 

       

       

      lbendlin wrote:

      Also note that "external" PowerApps come with limited functionality when used in a Power BI visual. Only "internal" (ie created from within Power BI)  Apps have the full integration experience.

      You you do raise an interesting point:  could I replace the above canvas app (form) with an interactive Power BI App? Could I then embedd this app in my report and allow it interrogate any metadat such as the Report Url  Again this would need to call the flow / stored proc as this the contract I am working to.

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        It's a great idea.  I don't think that is possible at the moment but I'll do some tests.  In the meantime please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com