Forum Discussion

EddieE's avatar
EddieE
Regular Visitor
3 years ago
Solved

PowerBIIntegration.Refresh() PowerApp workaround??

Hi, Does anyone know of a workaround for the PowerBIIntegration.Refresh() function inside a PA Visual using an Existing PowerApp?? I've just finished a PowerApp - built separately, not using 'Create...
General Comment
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    There is no workaround, you need to start over.

  • EddieE's avatar
    EddieE
    3 years ago

    lbendlin 

    Thanks mate. I was hoping for a better outcome - not to be.

     

    Seems this should be something that MS could look at fixing though, it's been an idea for 4+ years now. My current 'workaround' is for users to reload their browser to see their new data, ie

     

    1. user clicks company logo, triggers a bookmark that displays the app

    2. user makes edits / adds new data and submit form/s

    3. user clicks bookmark icon to 'go back to report' / hide app

    4. user reloads their browser to see new data

     

    Not ideal but works.

     

    Thanks again.

lbendlin's avatar
lbendlin
Super User
3 years ago

There is no workaround, you need to start over.

  • EddieE's avatar
    EddieE
    Regular Visitor
    3 years ago

    lbendlin 

    Thanks mate. I was hoping for a better outcome - not to be.

     

    Seems this should be something that MS could look at fixing though, it's been an idea for 4+ years now. My current 'workaround' is for users to reload their browser to see their new data, ie

     

    1. user clicks company logo, triggers a bookmark that displays the app

    2. user makes edits / adds new data and submit form/s

    3. user clicks bookmark icon to 'go back to report' / hide app

    4. user reloads their browser to see new data

     

    Not ideal but works.

     

    Thanks again.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      If it's any consolation - once you started over and connect to a SQL server table in Direct Query mode you can make this a nearly seemless experience for your users. Push the PowerApps button which writes the user comments to the SQL table and then issues a Powr BI refresh which surprisingly works despite fact that the data source is direct query, and a couple seconds later the user has visual confirmation of the changes they just made.

       

      What we really need is CDC  - the ability to write into the dataset that is currently in memory, and at the same time to write back into the data source. It can be done - other BI vendors have shown that.

      • EddieE's avatar
        EddieE
        Regular Visitor
        3 years ago

        lbendlin 

        I think that refresh can only be seen if I turn on auto page refresh - is that correct? I don't see minor changes comeing through from SQL to the report unless I reload my browser page.

         

        Yes, CDC would be nice - or something similar. I'm catching up with a MS rep next week on another matter and maybe I can convince them to have another look at this? Wait and see what comes of that meeting I guess 🙂