Forum Discussion
Power Apps for Power BI Visuals
- 1 year ago
You can export the data that is in the Values columns of that visual at that moment in time. You cannot export data from inside the PowerApp visual.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
- Anonymous1 year ago
Step 1 is to connect connect your Power BI visual to a Power App. That can be done either by creating a new one or by connecting to an existing one. The link I shared for Shane Young tells you how to do that. Once that is done you can see up your Power App however you need to in order to visual your data. If your intent is to see the data as it is filtered in a table like format, I would use a gallery.
For steps 2 and 3 you can look here for a good tutorial.
Power Apps Export To Excel As A CSV File – Matthew Devaney
Step 2 is to prepare your data for export. This is done by using the OnSelect attribute of your button. The best format to do this is JSON. Here is an example set.
Set( varJson, JSON( ForAll( Gallery1.AllItems, { json attribute 1: gallery value 1, json attribute 2: gallery value 2, json attribute 3: gallery value 3, and so forth } ), JSONFORM.Compact ) );Step 3. Prepare your dataflow. See link above.
Step 4. Launch your dataflow using your button with
Launch(Export2CSV.Run(varJSON).link)
The link attribute at the end there runs your data flow and gives you the link to the file. If it all works correctly a dialogue box will pop up with the link to the file you just created in your SharePoint.
Please let me know if you have any issues with this and I will try to help you through the process more. The two links I gave you should give you all the information you need though.
sure, you could also sow a button to your cheek (don't do that! - just a figure of speech)
The OP was looking for the standard Power BI Visual Export functionality via the ellipsis.
Your approach is possible but I would not call it "simple" and certainly not consistent with the general Power BI UX.
Anonymous and lbendlin , I saw the youtube video you mentioned and I understand how he sets up his e-mail button, which I am guessing is what you are referring to in your original message. However, he does that with the data source connector available to him and I didn't see any power automate flows created or used. How would I go about adding a button that exports the data, taking into account the active filters in the report (one filter is a single choice filter that changes constantly depending on the user), using Power Automate?
- Anonymous1 year agoNot applicable
Step 1 is to connect connect your Power BI visual to a Power App. That can be done either by creating a new one or by connecting to an existing one. The link I shared for Shane Young tells you how to do that. Once that is done you can see up your Power App however you need to in order to visual your data. If your intent is to see the data as it is filtered in a table like format, I would use a gallery.
For steps 2 and 3 you can look here for a good tutorial.
Power Apps Export To Excel As A CSV File – Matthew Devaney
Step 2 is to prepare your data for export. This is done by using the OnSelect attribute of your button. The best format to do this is JSON. Here is an example set.
Set( varJson, JSON( ForAll( Gallery1.AllItems, { json attribute 1: gallery value 1, json attribute 2: gallery value 2, json attribute 3: gallery value 3, and so forth } ), JSONFORM.Compact ) );Step 3. Prepare your dataflow. See link above.
Step 4. Launch your dataflow using your button with
Launch(Export2CSV.Run(varJSON).link)
The link attribute at the end there runs your data flow and gives you the link to the file. If it all works correctly a dialogue box will pop up with the link to the file you just created in your SharePoint.
Please let me know if you have any issues with this and I will try to help you through the process more. The two links I gave you should give you all the information you need though.
- bbAD1 year agoFrequent VisitorAwesome, thank you for all of the information. I appreciate your help!