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 ...
General Comment
westerdaled's avatar
westerdaled
Frequent Visitor
4 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
Icon for Super User rankSuper User
4 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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    I poked around a bit but the "PowerBIIntegration"  object only seems to have a ".Data"  attribute. There's no trace (as far as I can tell) where the data came from.  Maybe if you examine the app code download it may reveal itself.  This here URL is less than helpful

     

    Set up Power BI integration - Power Apps | Microsoft Docs

    • westerdaled's avatar
      westerdaled
      Frequent Visitor
      4 years ago

      Yes I agreee . Even If I was to unpack the canvas app , I am not sure how I could get to any info in the data object.  It is an interesting idea tho. I wonder if we could calll on jQuery to see if we can extract details from the report. 

       

      I have seen docs covering adding the BI Report to canvas app and also a model driven app, but this does seems be moving away from what should be a simple requirement.