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
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.