Hi! Is it possible for an app to connect to a PowerBI dataset and get the data and display it in a gallery. Or populate a dropdown with data coming from a PowerBI data set?
I was able to add PowerBI as a datasource but the only function I can see is refresh a dataset or add rows to a dataset.
Hi @mjbcruz ,
You can Use the PowerBi Connector to Connect with PowerBI DataSet.
For reference. -
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
This is if you embed powerapps in powerbi dashboard. I was able to do this.
But can you do the same from a canvas app (not a power apps visual).
Hoping anyone has an answer to this. How can I access Power BI dataset from a canvas PowerApps (not an embedded app in Power BI dashboard) and display it as a gallery.
@mjbcruz Did you find the solution for this?
I also want to get the data from Power BI dataset inside canvas application. I have found the Power BI connector and this action Run a query against a dataset.
I used below on button click to collect the data from table:
ClearCollect( colPBIData, PowerBI.ExecuteDatasetQuery( "1c6b8646-abcd-4f8e-93a9-e009de5e5fea", "832aeebf-wxyz-4e72-8bbc-6bda64b3d235", "EVALUATE Values(Geo)" ).firstTableRows )
When I add CountRows(colPBIData) in Text property of label, it shows the correct number of rows in dataset table. But, I am unable to show this data in gallery.