Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI Dataset Table Linking with PowerApps

Hi,

 

I have a dataset on Power BI Service which has a Table named "ProjectTasks". This table has 7000 rows of data and 12 columns

The data is updated every 4 hrs and I want to create a power app using that data

 

I know powerapp Dataverse allows PowerBI tables integration but the premium connector will be costly as the number of users are more.

I have created a flow uptill now to create CSV Table from the data. Attaching the image here.

 

 

 

 

 

 

 

 

 

 

 

 

The flow is running the following Query for "Run Query against dataset"

DEFINE
VAR Datatable=
'ProjectTasks'
EVALUATE
Datatable

The output is then used to create CSV Table.  I dont know further ways to link this to a PowerApps

 

I have also created a sharepoint list with the table headers

Is there a way to update the list or maybe create an excel table on sharepoint with this data whenever the flow is triggered?

 

This would really help!

 

 

No Replies