Thank you very much, you helped me achieve it, since no other tutorial for doing this was working for me 🙌
@michellejamison6263
Жыл бұрын
This was a very helpful video. Thank you for sharing.😃👍🏾
@alvisgosai9468
2 жыл бұрын
Thanks bro, this helped a lot. Do you know of a way on how to save the visuals into different sheets inside same Excel Workbook? I have different visuals in my report which I want to export to excel and send email as 1 workbook instead of many different single excel files
@ritwickgoswami8187
2 жыл бұрын
Thanks Dhruvin!! This is an amazingly detailed tutorial. Super helpful
@raffikouzoudjian938
Жыл бұрын
Hello, Thank you for the details step by step explanation but the export is really taking too long! I believe "adding records one by one" to excel is taking time! Basically, I tested the flow on 300 records with 10 columns. The flow is running for more than 30 minutes now. Am I doing anything wrong? Thanks
@AdminBroudys
11 ай бұрын
Greate example I followed one of your other videos and it worked out great I tried the export to excel but I get incomplete data empty colums the email is even worse almost no data
@Rithanya.suhanya-0730
11 ай бұрын
Nice and very clear, thank you so much
@sankarann
2 жыл бұрын
This was helpful. One question though. Is it ok to just add the data to the template we created, send the email and then delete the rows again? This way I dont have to use create file actions. Will this impact multiple users exporting data at the same time?
@rohanlokhande
2 жыл бұрын
If visual having more data(greater than 400) then this workflow taking more than 10 mins. do you have any suggestion to optimize the processing time?
@sanprasa1
Жыл бұрын
Hi Dhruwin, great video, can we prompt the file to open after triggering the button, like downloading
@GaryLawrie-t9y
2 ай бұрын
Great vid but wish you had of mentioned the limitations at the beginning
@mickygupta2696
2 жыл бұрын
Thanks for this video... I just want to add and ask you that instead of creating a new file everytime, is that possible to append the data in existing file, or replace the existing file with new data
@tajudeen2
Жыл бұрын
Hi Druvin, Thanks a lot for the wonder Video. It helped me a lot. It will be grateful if you can share the working files too.
@sitarap7403
Жыл бұрын
Thanks for the video.One question can we export more than 2000 records from power BI to excel through power automate?
@jitu0583
2 жыл бұрын
This is wonderful video, just one question...do we need to create this template excel file in one drive of all users, if they want to export data in excel using power automate?
@jorgechoreno602
7 ай бұрын
Good video brother. When the flow is executed by another user in the PBI, it returns an error until the flow is shared with said user in Power Automate. How can it be solved so that any user can run it?
@chalanatyjostna2229
Ай бұрын
Is it possible to save 10 visuals in different 10 tabs in the same workbook? If so, how can I configure that please let me know
@anujasule8077
2 жыл бұрын
thank you. i have implemented steps as mentioned in your video. Do I required to give access to each user in automate flow as a owner? IF not how I can implement this ? If i don't provide access It says unusual error when they try to access the report , If i added them into owners group then they can export the data. But it is not feasible to provide owner access on the flow to 200+ users...Any help will be appreciated.
@Karunakar4620
2 жыл бұрын
Add AD group that has all users.
@nivi5476
7 ай бұрын
thank u so much sir.but the data type is mismatching. my power bi table contain percentage column .but it comes to excel with general data type .how to clear this issue sir
@monishpilla4137
Жыл бұрын
Hi Dhruvin, Great video, I need few information 1)Can I do this same process in power Automate app and can i get the same result. I tried it but could not. 2)I have PPU license and I am not able to do same steps that u have done in Power automate visual in power service, Can you please provide suggestion on it please.
@gustavoleo
2 жыл бұрын
Fantastic! Congrats!
@gislijonsson5336
Жыл бұрын
Hi .. Excellent video :) - can it filter out only lines from the table that are with dates from the current month and past month. - and and more.. if I have list of customers that it filters out data from each customer and makes a file for each and sends it customer data to each one only with data value for him.
@cvalarcon
Жыл бұрын
Hi Dhuruvin Thanks for this ideo, I have a question , so I need to export an excel table with particular format (title , Subtitle, and data) but no to need to export to OneDirve but locally in your Pc , How can I do this ? Thanks
@hebustech
2 жыл бұрын
Hi, Thank you very much. I'm looking for this solution since a lot of time. To complete I had a section : Delete file after the second step and now I can update when I want the same file and share the link to this file with my users. (Now I need to find a solution to parameters columns in Excel (for exemple value in euro for one column) but it is ok perfect
@arvindchauhan5241
2 жыл бұрын
can we use scheduled flow to trigger the button flow ? Like inside scheduled flow can we pass button flow ?
@KumarSai-kc6bn
Жыл бұрын
Actually, we cannot schedule the flow to trigger the button.
@DNSXH1
2 жыл бұрын
Thanks! I have a question, the flow doesn't get triggered when i click in the power automate button from the public web dashboard. Is there a way to fix this?
@divya7555
2 жыл бұрын
Hi Dhruvin, Thanks for this.. :) Great help.. I have one more requirement along with this, I need to put all excel information in the body of the mail along with the attachment. and my columns are sales data like a quarter, day, sellout, and inventory ... I would need to show a grant total of sellout and inventory as total in the last raw of excel attachment and in the body of the mail. please help.
@lifenaturetechnology2554
2 жыл бұрын
Any solution you have found it Divya?
@timewithsopy
Жыл бұрын
Thanks for the vid. QQ. I have a connection to our published powerbi dataset from excel. I want to filter in the connection, can I do that? I cannot see a way to do it without using the pivottable field filter section.
@nicolewusf
Жыл бұрын
Great Video - I am looking for a flow - to create 2 excel files from Power BI using power Automate and email - is a video exist ?
@mukkunarayanreddy6298
2 жыл бұрын
Hi Dhruvin, it’s a wonderful video and it’s working as expected. Could you please help in scheduling the flow with same steps.. I tried with recurring schedule option but it’s not working.. please help on this or point me to any existing videos plzzzz. Thanks, Narayan
@iamdhruvinshah
2 жыл бұрын
Not possible to create recurring flow
@ExCoTech13
2 жыл бұрын
@@iamdhruvinshah how we can export power usage matrix report live dataset.
@arvindchauhan5241
2 жыл бұрын
@@iamdhruvinshah I have created with recurring flow with the help of dataset. I am able to achieve the task as per needed
@Pankajkumar-cq4kf
Жыл бұрын
Thanks Dhruvin, Can you help me on how to export data in embedded link of powerbi.There is no export button in more option.
@abdoulazizkebe2020
9 ай бұрын
hello, I would like to know if you have any documentation or tutorials on setting up a cloud flow plan to automatically retrieve a Power bi table with Power automate without trigger button.
@yashashri9777
11 ай бұрын
Did you find a way to export more than 1k records? It takes more than 15 minutes for 200 and above records. So is there any way to improve performance?
@sandhyakandaswamy2846
Жыл бұрын
Hi Dhruvi, i have created flow based on ur vedio, excel file is creating but data not in loading into excel. May I know wat mistake I have done. Could you please help
@pro1427
2 жыл бұрын
amazing, where can i learn more about power automate?
@amitsah596
7 ай бұрын
@Dhruvin shah How to format date in dd/mm/yyyy ? in your exported data, date format is 2019-05-26T00:00:00. i am also facing same issues. i need only 2019-05-26 in date column Thanks in advance
@suhas7230
2 жыл бұрын
Hi Dhruvin, Will this method also restrict you to download only 1000 rows of data?
@iamdhruvinshah
2 жыл бұрын
Yes!
@nooralfar10
2 жыл бұрын
What if I just want to fill the data dynamically; I have a layout in excel just need to fill values
@ranbirwadhawan6327
2 жыл бұрын
Hi Druvin, Excellent video. However when we are changing dates from Power bI filter it is not updating the excel file? Any suggestions
@NishthaTank
Жыл бұрын
Helllo sir , if the visual is matrix and if we want the data in excel as same format as in matrix not in summarised form , is it possible sir
@GeorgeGourgoulias
Жыл бұрын
i added the select (but no power bi data option appears...)
@brijendraydv
2 жыл бұрын
Great and Thanks but latest update already allows you to export filtered data then how's its different from that 🤔
@iamdhruvinshah
2 жыл бұрын
It's sending Excel attachment in Email as well. It's clicked from custom button.
@brijendraydv
2 жыл бұрын
@@iamdhruvinshah ya ya but someone is still opening the PBI report and clicking button :P after this update not good usecase but I can see other possibilities
@rasikhussainj2937
2 жыл бұрын
hi bro, your video looks good but we have one doubt while publishing our report as web public if this export button will work? or let me know have facing any issues?
@sanprasa1
Жыл бұрын
Hi Dhruvin, Exporting data taking six minutes to export only 150 records
@SanthoshKumar-wo2nb
2 жыл бұрын
Hi Dhruvin, Is there any way to export more than 1000 rows of data from Power Bi through power Automate?
@iamdhruvinshah
2 жыл бұрын
No
@gabrielchavezmo
2 жыл бұрын
Thank you, it is very useful! I only have one question: can you program this flow (every Monday, fox example) instead of clicking the button?
@iamdhruvinshah
2 жыл бұрын
No
@arvindchauhan5241
2 жыл бұрын
@@iamdhruvinshah Any other option to fulfill the above requirement
@arvindchauhan5241
2 жыл бұрын
Yes I got one solution where you can send data without clicking button as per your requirement
@kwil3business
Жыл бұрын
@@arvindchauhan5241 What is the solution?
@sthothat
2 жыл бұрын
Hi Dhruvin, Excellent Video, Way you explained the flow which help me to replicate the scenario I want to do. I had one failure Create table failure. I had introduced a Delay of 10 minutes after Create file, still having the issue. Message in Output is Item not found. Can you guide me.
@sanprasa1
Жыл бұрын
Hi, I am having same issue, table is creating however it take long delay but data not populating, any idea
@KumarSai-kc6bn
Жыл бұрын
Hi Dhruvin, Great video. If we change category name in the report and then click on button, will the filtered data updated in the excel?
@williamleveson-gower5088
2 жыл бұрын
Great video !!!, thank you for sharing. I was able to build one using sharepoint instead of OneDrive. I am also using a shared emailbox instead. One quick question, is there a way to schedule the same flow instead of being triggered by a click?.
@Karunakar4620
2 жыл бұрын
I am able to create the report file into share point but not able to insert the rows, failed at that step can you pls help
@divya7555
2 жыл бұрын
Hi Dhruvin, couldn't find the code from Github, My bad, could you please help me?
@nicolapelagatti6804
2 жыл бұрын
Hi Dhruvian, congrats, very interesting vide 2 questinos first, if I have one table in power bi and I have to separete it into different excel files with only one button , I have some possibility? second, could I automate the export without click? could I schedule the excel export? thanks a lot
@majidbhatti6117
2 жыл бұрын
good question, i am also waiting to hear from @Dhruvin
@buddhigupta3557
2 жыл бұрын
If you use Paginated report for table to be downloaded, it can be automated.
@arvindchauhan5241
2 жыл бұрын
I have solution for this first you have to take the dataset of your table then you can achieve the task without button click
@navaneetharajuramesh8462
2 жыл бұрын
Hi Dhruvin, Thanks for the video. I used your method, and i created the flow its working fine. can you please tell me how can my company users will access the button, and get the excel in their drive folder.????? Urgent....
@Karunakar4620
2 жыл бұрын
Where you able to achieve it?
@renjithpl
Жыл бұрын
Hi how to apply a RLS into this step???
@rajnishrajput2367
2 жыл бұрын
Hi Druvin Thanks for the video The date format in the excel is different than mm/dd/yyyy, is there a way to change date format?
@dapperlink
2 жыл бұрын
This was very helpful. There was one thing I missed. I never saw how to filter the row data being appended in. What if you had 10 categories but wanted to filter for just one? Do you have a video for that? Thanks again!
@houssemabdelkefi1405
2 жыл бұрын
hey did you find any solution please ? I'm looking how to export a dynamic matrix to excel.
@dapperlink
2 жыл бұрын
@@houssemabdelkefi1405 Sorry, not yet.
@SuSanNg-gx8qr
Жыл бұрын
Why the button of mine not able to trigger
@juanruz
2 жыл бұрын
Genial...!!!! Gracias.
@SankalpStudySuccess
2 жыл бұрын
Hi sir.. how do I reach you
@Karunakar4620
2 жыл бұрын
Great Video, can we trigger email with the excel attachement to user dynamically who ever clicks the button ?
@vikasshahvikas
2 жыл бұрын
Did you find the solution?
@Karunakar4620
2 жыл бұрын
@@vikasshahvikas yes, we did it using power Automate using dynamic field power bi user
@alvisgosai9468
2 жыл бұрын
Thanks bro. Just one question, for the 'Create table' part, instead of OneDrive,. I want to create table in Sharepoint. What shall I use for 'Location', 'Document Library' and 'File'
@Rakesh_RV
Жыл бұрын
if you use it?
@vishnuprasadvs3627
2 жыл бұрын
Hi Dhruvin, Is there any solution for Export Power BI report to PDF with applied filters from Power BI button using Power Automate?
@nagasathiyen5750
2 жыл бұрын
Hi Vishnu / Dhruvin, Am also looking for solution for same use case where we can export Power bi report after applying Report level filters but the option is not working.. i.e. the report level filter is not applying while exporting to PDf. If you get any solution for the issue please let me know.
@rajnishrajput2367
2 жыл бұрын
Check this out kzitem.info/news/bejne/1q2gtXqPs193q4I
@rajnishrajput2367
2 жыл бұрын
@@nagasathiyen5750 Check this out kzitem.info/news/bejne/1q2gtXqPs193q4I
@arvindchauhan5241
2 жыл бұрын
@@nagasathiyen5750 You can use dataset to filter the filed in your report. I have completed the same kind of task
@sunilmathadious7799
2 жыл бұрын
I tried it, Column with Numeric values not showing in final excel report, could you please let me know how to enable it.
@sunilmathadious7799
2 жыл бұрын
This does not even shows Date and large numeric values
@vinodh6425
2 жыл бұрын
Hi dhruvin Amazing videos can we do refresh the data when we get data from one drive ?
@vinodh6425
2 жыл бұрын
In above particular video
@sowmyadj7141
2 жыл бұрын
how to add fields for power automate in power bi desktop version
@arvindchauhan5241
2 жыл бұрын
can we trigger the automate button to scheduled time?
@iamdhruvinshah
2 жыл бұрын
No
@arvindchauhan5241
2 жыл бұрын
@@iamdhruvinshah Any other way can we take power bi data for schedule flow?
@guptaneel11
Жыл бұрын
how to export filtered data for power automate in power bi desktop version
@tylerkolota
2 жыл бұрын
Need to update and/or create many rows in Excel? Try Excel batch actions in Power Automate: kzitem.info/news/bejne/qZ97u2dqgqpmmnY
Пікірлер: 101