get data from powerapp

[Vikkers]

Hi

I have a questionaire set-up in PowerApps. I want to use Power BI to create a report. But I have no clue how to get the data. I don't use Dataverse.

[v-csrikanth]

Hi @Vikkers 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @Vikkers 
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards
Cheri Srikanth 

[v-csrikanth]

Hi @Vikkers 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth · Accepted solution]

Hi  @Vikkers

• To transform the dataset in Power BI using Power Query so that each Qtr_Year becomes a separate column containing the corresponding Ctgy values, start by opening Power Query Editor.
• Select the columns Code, Grp, and Name, then use the Group By feature, setting the operation to “All Rows.” After grouping, expand the resulting column to bring back Qtr_Year and Ctgy.
• Next, pivot the Qtr_Year column by selecting it and choosing “Pivot Column.” Set Ctgy as the values column and choose “Don’t Aggregate” or an appropriate aggregation method depending on your data.
• Once the pivot is done, each quarter will appear as its own column with the corresponding Ctgy values.
• Make sure that the combination of Code, Grp, and Name uniquely identifies each row to avoid unintended aggregation. Finish by applying the changes to load the transformed data into your model.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @Vikkers 

To connect Power BI to a Model-Driven App, open Power BI Desktop and click on Get Data. Select Dataverse from the list and connect using the credentials that have access to the environment where your app is hosted. You'll be prompted to choose an environment URL.

Once connected, Power BI will display all available Dataverse tables. From there, select the tables that store the question and answer data from your app, then load them into Power BI.

After loading, you can start building your report using those tables. To keep the data updated, publish the report to Power BI Service and configure scheduled refresh using an organizational account or service principal.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[Vikkers]

when I select Dataverse nothing happens

[v-csrikanth]

Hi @Vikkers 
To get data from PowerApps into Power BI without using Dataverse, You can follow the below approaches:

1. Use SharePoint or SQL Server – Store PowerApps data in SharePoint lists or an SQL database, then connect Power BI to these sources. 

2. Use Power Automate – Automate data transfer from PowerApps to an Excel file in OneDrive or SharePoint, which Power BI can connect to.

3. Export to Excel or CSV – Manually export data from PowerApps to an Excel file and import it into Power BI.

4. Use a Custom Connector – If your data is stored in an external system, create a PowerApps custom connector and pull the data into Power BI.

Note reference links: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list 
https://learn.microsoft.com/en-us/power-platform/admin/security/data-storage 

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[Cookistador]

Which datasource did you use to build your app?

A sharepoint list?

[Vikkers]

its a model driven app. the datasource is in the app. When someone completes a question the answer is held in a table within the app. I would like Power BI to pull from those tables.