Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Invoking Custom Function to insert new rows

Hi,   I'd like to build a report that allows users to manually enter values that will be appended into one table. The goal is for the user to enter specific values into parameters, and then this ne...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Maybe ImkeF has an idea.

 

My idea would be to use PowerApps to add parameters to a table. There is a visual for Power BI for PowerApps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mariusz and Greg_Deckler ,

     

    Many thanks for your answer. I'll give a try with PowerApps.

     

    But if someone has a solution that runs in Power BI Desktop only, that would be great.

     

    I'll answer here if I find a solution using PowerApps and Sharepoint List.

     

    Thanks again!

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      You wouldn't have to get SharePoint involved. PowerApps can use just about anything as a data source. And if Power BI was connected via Direct Query to that data source it would be effectively real time. I also think that there is a way to implement PowerAutomate (Flow) to add records to a Power BI dataset, which would effectively make it real time as well. Lots of options. 

       

      The problem with Power BI Desktop is that it was written for reading information and displaying it, not for data entry.