Connect Power BI to Form Output

[Stevie_Westside]

Good day to you all,
I am newish to PowerApps, after a very long hiatus, I've come back and everything has changed... for the better mind you.  However, in this new endeavor I am attempting to utilize the data from an app (submitted through a form), via model-driven app.  I am already collecting data, however, I have no idea how to find my data via Power BI 'Get Data'.  My tables created for the app show up under 'Dataverse', but those don't include the data output.

Is there something I am missing here, or can I really not connect to my form output via Power BI?

note: I realize you can 'visualize' using Power BI within the app, but my boss doesn't want to go into the app in order to view his data, he wants it on his daily dashboard (created through Power BI desktop).

Any info would be greatly appreciated.  Much obliged, Stephen

[Ammarz]

Welcome back to PowerApps! It’s great to hear that you’re diving into model-driven apps and looking to integrate your data with Power BI. To connect your form data from PowerApps to Power BI for visualization on a dashboard, you should be able to use the Dataverse connector in Power BI Desktop. Here’s a step-by-step guide to help you find and connect your data:

1. Open Power BI Desktop: Start by opening Power BI Desktop on your computer.

2. Get Data from Power Platform: Go to File > Get Data > Power Platform.

3.  Select dataverse connector : https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector

4. Choose Your Environment: In the list of environments, expand the one you’re working in.

5. Select Your Tables: Pick the tables you’ve created for the app that contain the data you want to visualize.

6. Load the data

ensure you have the necessary permissions to access the data in Dataverse.

[Stevie_Westside]

@Ammarz thank you for the information.

I've gotten this far, as far as connecting to my tables via the Dataverse connection in Power BI, however, it's the table I loaded into the app...

Why this is a problem... at least at first glance:
1. I used an SQL connector to pull in a report (table) into Power Apps
2. I built custom columns within this table
     a.  one of these columns was a boolean indicator (Review Complete: yes/no)
3. Used those custom columns along with columns from the report (table) to build a form.
4. Created a View for the report (not complete)
5. Created a View for the report (complete)

What I want to do is connect to the View (Complete).  I am trying to create a dashboard based on the results of the form.

So how do I use Power BI to connect to my form results? Or... does connecting to the Table via Dataverse contain my results?

Thanks again!

[Ammarz]

If I understand correctly, you want to access the filtered data (the complete view, for example). Could you confirm if I understood correctly?

[Stevie_Westside]

That is correct.  And if it's of any consequence, these tables are published in my personal environment, not the "Company" Environment.  I am working on exporting/importing my solution.  Not certain, but perhaps that may also play a role in accessibility.

[Ammarz · Accepted solution]

Suppose you want to load the data from the table based on a view. In that case, the views contain specific queries (FetchXML); I advise you here to redo the same filter, but with Power BI, you can see the filters a view by Editing this view, and then you apply this same filter that you need, but with Power BI directly.
Note: of course, you need the necessary permissions (read permission on this table with linked tables in case you need to do joins).

[Stevie_Westside]

Thank you so much @Ammarz I really appreciate your insight and guidance.  Much obliged.

[wudjsba]

This help me a lot, thanks.