Power App or Desktop

[thinker_02]

I have an Excel table, and I need to create a Power BI report based on this data. The report will involve filtering and transformations. Additionally, I want to provide users with the ability to add new rows to the transformed table, with these changes automatically reflected in the Power BI report.

Furthermore, users should be able to add comments to a specific column, and these comments should also be visible in the Power BI report.

Now, I’m wondering about the best approach and sequence for implementing these features. Should I start by creating a dashboard and then integrate a Power App, or is there a better way to solve this?

[v-xiandat-msft · Accepted solution]

Hi @thinker_02 ,

I think the best order is to publish the report to the service first, then do the power apps integration, followed by setting up a scheduled refresh to ensure that the data is updated each time.

About how to enable the power apps integration, you can find details from this link:

Enable the Power BI/Power Apps Solutions integration - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.