Forum Discussion
get data from powerapp
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.
Hi Vikkers
To get data from PowerApps into Power BI without using Dataverse, You can follow the below approaches:
-
Use SharePoint or SQL Server – Store PowerApps data in SharePoint lists or an SQL database, then connect Power BI to these sources.
-
Use Power Automate – Automate data transfer from PowerApps to an Excel file in OneDrive or SharePoint, which Power BI can connect to.
-
Export to Excel or CSV – Manually export data from PowerApps to an Excel file and import it into Power BI.
- 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.