Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Edit Power BI table via Power App

Hi everyone,   I tried to create a small Power App in a Power BI report to allow end users to edit data from a table directly in the Power BI report. This table was created in 'Enter Data' mode ...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

According to your description, I reproduced your problem, which may be caused by the format of the data source. I did the following test and successfully connected to the data source of powerbi.

You can refer to the following video and related documents, which can help you.

Manage connections in canvas apps - Power Apps | Microsoft Docs

Create and format tables - Office Support (microsoft.com)

Using PowerApps Visual in Power BI to interact with data 📈 (2019) - YouTube


Best Regards,
Henry


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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you v-henryk-mstf 

What's odd is that I can't even choose the Power BI report where the table that I want to be updated is located.
When I choose the Power BI connector among the datasources, I just have 'Power BI' and the email that I logged in with.
I have no possibility to choose among the different Power BI reports that I have in my desktop.

I followed the links you kindly provided but to no results.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Can you provide more information screenshots so that I can find out the problem accurately and answer you as soon as possible.


    Looking forward to your reply.


    Best Regards,
    Henry

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      v-henryk-mstf 

      The first screenshot below is a form that I want to connect to my Power BI table to be enable users to edit the table via this form:


      Then I click on "Connect to data" and then "Add data" as on the second screenshot below:

       

       

      Then I look for the "Power BI" connector as below:

       

       

      I click on the connector, and I have the below screen with my email address (that I've hidden) with I used to log in powerapps:

       

      I then have the below screen:

       

      But unlike your example, I have no table to select, not even a Power BI report to select. The datasource parameter on the right stays at "None" ("Aucun" in my example, in french).

      Please let me know if you need anything else.