Forum Discussion
Free text table
Does anyone know of a visual that is a table that you can type into? I have a report with various visuals, but want a table to be able to type in comments relating to the data. Currently I have multiple text boxes all next to see each other to look like a table, but that is far from ideal.
Hi sbott
Unfortunetly No, we dont have any type visual which accepts user input in a table form.
But you can cjeck this video this might help you.
https://www.youtube.com/watch?v=AvsobztNXtc
https://www.youtube.com/watch?v=6Zi6p0aJeI4
https://www.youtube.com/watch?v=s8LJPZhvgVQ
https://www.youtube.com/watch?v=0ZlGTIGrELo
https://www.youtube.com/watch?v=uPHwjPRnRwE&t=1s
I hope above videos might help you!
I hope I anwered your question!
Hi sbott ,
As far as I know, Power BI report only support importing and analyzing data, it does not support writing data directly in the data source. However, you can embed the report into a web page or application and write data to the data source through code. This requires a lot of additional knowledge.
If your data source has a connector in Power Apps and supports reading and writing, you can embed the Power App in report and update the data through Power App.
Add data connections to canvas apps - Power Apps | Microsoft Learn
Update and UpdateIf functions - Power Platform | Microsoft Learn
Embed a new Power App in a Power BI Report. - Power BI | Microsoft Learn
Then, you can then use Power Automate to monitor the data source. For example, create a cloud flow to monitor whether any data has been modified in the data source, and if so, then update the semantic model of the report to show the latest data.
Take Dateverse as example.
Trigger flows when a row is added, modified, or deleted - Power Automate | Microsoft Learn
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI
Best regards,
Mengmeng Li
3 Replies
Hi sbott
Unfortunetly No, we dont have any type visual which accepts user input in a table form.
But you can cjeck this video this might help you.
https://www.youtube.com/watch?v=AvsobztNXtc
https://www.youtube.com/watch?v=6Zi6p0aJeI4
https://www.youtube.com/watch?v=s8LJPZhvgVQ
https://www.youtube.com/watch?v=0ZlGTIGrELo
https://www.youtube.com/watch?v=uPHwjPRnRwE&t=1s
I hope above videos might help you!
I hope I anwered your question!
Many thanks, I will check them out.
Hi sbott ,
As far as I know, Power BI report only support importing and analyzing data, it does not support writing data directly in the data source. However, you can embed the report into a web page or application and write data to the data source through code. This requires a lot of additional knowledge.
If your data source has a connector in Power Apps and supports reading and writing, you can embed the Power App in report and update the data through Power App.
Add data connections to canvas apps - Power Apps | Microsoft Learn
Update and UpdateIf functions - Power Platform | Microsoft Learn
Embed a new Power App in a Power BI Report. - Power BI | Microsoft Learn
Then, you can then use Power Automate to monitor the data source. For example, create a cloud flow to monitor whether any data has been modified in the data source, and if so, then update the semantic model of the report to show the latest data.
Take Dateverse as example.
Trigger flows when a row is added, modified, or deleted - Power Automate | Microsoft Learn
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI
Best regards,
Mengmeng Li
