How to create a Export to Excel / CSV button in Power BI

Поделиться
HTML-код
  • Опубликовано: 1 янв 2025

Комментарии •

  • @CurbalEN
    @CurbalEN  2 года назад +3

    I found a way to export up to 100k rows to Excel, check it here:
    ruclips.net/video/WsbIXJDhC_o/видео.html&ab_channel=Curbal

    • @analyticsadda6080
      @analyticsadda6080 2 года назад

      Excellent video but it has limitation of 1000 rows how to overcome this

    • @CurbalEN
      @CurbalEN  2 года назад +1

      The comment you commented on has the solution

  • @CurbalEN
    @CurbalEN  3 года назад +9

    If you want to automatically export to excel without user interaction and schedule it, here is the way to do it instead:
    ruclips.net/video/VmZUOcUD0qY/видео.html&ab_channel=Curbal

    • @pascalgomringer228
      @pascalgomringer228 3 года назад

      Works great!
      I'm having issues though with special characters such as ä, ö or é.
      My source is encoded as ASCII and from what I understand the output will be UTF-8 using your tutorial.
      Is there a way to get an outpot encoded as ASCII?

    • @josefinagaccio2362
      @josefinagaccio2362 2 года назад

      how do I do it if what I have to export is a metric result?

  • @praveenkumar_9143
    @praveenkumar_9143 Год назад +1

    Today I have learned something about Power Automate for the first time and I really liked it's flow of execution and well explained Ruth!!😄😊

  • @Adam-cd3xd
    @Adam-cd3xd 3 года назад +2

    Thank you so much, that is very helpful! My managers "Can we export that to excel?" will be thrilled to bits!

  • @thomasday3226
    @thomasday3226 3 года назад +1

    Wow, Ruth---what a great video and a lucky google search to find your channel. Bookmarked and subscribed. Thanks! Tom

  • @peterthompson9412
    @peterthompson9412 2 года назад

    Excellent explanation, thank you. I have used Power Automate to export details of the currently selected Power BI item(s) to Microsoft Lists. Subsequently importing the list back into Power BI during the Scheduled Refresh. This means that I can present a list of data to the users, and allow them to mark items as 'Checked off' and refresh the view when the next load of items comes into Power BI. It does require the items to have a unique identifier to ensure things don't get confused, but this is a relatively simple field to create on each table - which is linked back to the imported List. If there is a need to add an explanation, these can be prepopulated in each Power Automate Flow, or more complicated explanations can be entered in Lists by editing the appropriate record (which is a little more work, but completes the user experience).

    • @CurbalEN
      @CurbalEN  2 года назад

      Bravo!! 👏👏

  • @brettfarmer7708
    @brettfarmer7708 2 года назад

    I think cumulatively she has saved me about 100 hours of labor effort. So thankful.

    • @CurbalEN
      @CurbalEN  2 года назад

      So proud to hear 😊😊 and thanks for the feedback !

  • @KaushalKishoreDixit
    @KaushalKishoreDixit 2 года назад

    Ruth, I Love You 😘
    This trick saved a lot of my time and firms money. As always you are awesome 😁

  • @scfo
    @scfo 3 года назад

    This feature will be incredible for things like mapping new accounts, projects, employees etc to their different categories. Really great video. This one will get saved in a special folder. Thank you so much.

    • @CurbalEN
      @CurbalEN  3 года назад +1

      And I have more even greater, stay tuned!

  •  3 года назад +2

    Now this one is my favorite update this year so far, particularly this export functionality. It's so useful. Great example Ruth, thanks! 😊

    • @CurbalEN
      @CurbalEN  3 года назад +1

      And more to come! Power Automate and Power BI together are unstoppable!!

    •  3 года назад

      @@CurbalEN I can't wait to see more! 👏🏻😃

  • @lenzypetty9371
    @lenzypetty9371 3 года назад

    Awesome...perfect timing...I just got a request to make it easier for end users to export to excel. Really Really Great Video! So grateful you did this video.

    • @CurbalEN
      @CurbalEN  3 года назад

      Really happy I did it too, it seems to be useful :)

  • @byarian
    @byarian 3 года назад +2

    Thank you for the video! Is it possible to have the button export to the user's local desktop or does it have to be in the cloud?

    • @CurbalEN
      @CurbalEN  3 года назад +1

      I think so, haven’t tested it yet though…

  • @Igor-oc4om
    @Igor-oc4om 3 года назад +2

    Greeting. Thanks for the video!
    Is it possible to export data and reports published on the web? Thank you

  • @saurabhgadre1
    @saurabhgadre1 3 года назад

    Very awesome update. Last month i was trying to get data but not able to convert it to excel. Thank you for sharing this :)

  • @dt0229
    @dt0229 3 года назад +2

    How do you do dynamic save, allow a pop up for user to choice where the file should be saved instead of pre-defined location. Thanks

    • @nirmalyaroy1881
      @nirmalyaroy1881 3 года назад +1

      Good question. I have also the same query subscription instead of saving file in share point how do user dynamically save file

  • @shadowitself
    @shadowitself 2 года назад

    I hope devs from MS are taking Your remarks deeply into hearts :)
    U'r really cool flow (and not only) flow tester :)
    thanks

    • @CurbalEN
      @CurbalEN  2 года назад

      Feeling the flooooow ;)

  • @VladMZ
    @VladMZ 3 года назад +3

    We could do this before with buttons calling FLow REST API, but it's very neatly packaged into a visual now.

    • @CurbalEN
      @CurbalEN  3 года назад

      Yeah! Power to the (business) people! 👊

  • @kasarosiahnohp434
    @kasarosiahnohp434 3 года назад +2

    Amazing!!!
    So, I wonder if it can connect to google sheet?
    like when click button, it will updates to new row in specific sheet,
    or it is possible to automatically daily update to the sheet around midnight?

    • @CurbalEN
      @CurbalEN  3 года назад +1

      For schedule export use this:
      m.ruclips.net/video/VmZUOcUD0qY/видео.html

  • @eleftheriosioannidis2144
    @eleftheriosioannidis2144 3 года назад

    Well done Ruth for all you useful videos!
    I would love to see how we can create a button that can send the filtered data by e-mail
    e.g. Table [Monthly Sales per Employee]
    - Filter table by desired Employee
    - Send to the selected Employee
    Thank you again for all your videos!

    • @CurbalEN
      @CurbalEN  3 года назад +1

      This should help you. Use email address as a data field to avoid hardworking the email :)
      m.ruclips.net/video/lqlYl3pVL1g/видео.html

  • @Reginaldpenguins
    @Reginaldpenguins 3 года назад +1

    Thanks for this Ruth excellent as always! I'd love to see more of your ideas on what could be done with this new Power Automate functionality

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Will do more videos ;)

  • @sophiatoh4527
    @sophiatoh4527 3 года назад

    Excellent video as always Ruth! Thank you for your videos, they are very helpful in my Power BI learning journey. Looking forward to seeing more videos about Power Automate with Power BI! :)

  • @yeraldo05
    @yeraldo05 3 года назад

    What an awesome feature!!! That's why I'm also learning Powerapps and Power Automate thus I can improve my skills.
    Thanks for the great work, keep it up!!

    • @CurbalEN
      @CurbalEN  3 года назад

      Excellent! You will not regret learning those skills!!

  • @alejandroperez5384
    @alejandroperez5384 3 года назад +3

    Excelent video, thanks a lot
    QQ: is there a way to export the file directly into a local folder? Im looking into letting the user export the data in a csv when they are looking at the report in the Power BI server, thanks!

    • @sachinkumar.ddikky1110
      @sachinkumar.ddikky1110 3 года назад +2

      I guess no. if anyone has a solution to this. please make a video on it.

  • @Komal_Shubham
    @Komal_Shubham Год назад +1

    can we use local drive to export data apart from sharepoint and one drive
    ?????????

  • @Spartanboy123
    @Spartanboy123 2 месяца назад

    Great Video!! thanks for sharing. Is there a way to retain conditional formatting in powerbi tables one generating a excel file?

  • @franciscoperireis7866
    @franciscoperireis7866 3 года назад +1

    Very interesting! Is there a way to do this for all the rows from a table?

  • @Shivani-r1r
    @Shivani-r1r 4 месяца назад

    Can we do something to expand the scope of the export button, like numbers of all the screens get exported to the excel file at once through a single button?

  • @Howard_Martinez
    @Howard_Martinez 2 года назад

    Thanks Ruth, Could I add a previous step to create a new excel file? to generate a new file every time I run the flow.

  • @AaronElliottKC
    @AaronElliottKC 2 года назад

    Great explanation! Very simple steps. Thank you so much!

  • @therajbam
    @therajbam 3 года назад

    Thanks for showing the way to export the data from power query. what about if I have visual (data grid) and want to automatically export to CSV file?

  • @nachomiranda5151
    @nachomiranda5151 3 года назад

    Thanks Ruth. As always, great and very useful video
    From my modest point of view, this feature looks like a recently born baby, very limited yet, but plenty of potential to be developed.
    Let´s cross our fingers for they to put lot of hours on making this better and better
    Please, keep on making videos on how to apply this feature on other ideas
    Thanks a lot

  • @soy34mb
    @soy34mb 3 года назад +1

    Love it. Please make more videos about this new feature. Thanks!

    • @CurbalEN
      @CurbalEN  3 года назад

      I will, love it too :)

  • @larrybellamy6114
    @larrybellamy6114 2 года назад

    Excellent demo processes, do you have a specific practice file that I can use? I cannot find one in your download folder as you suggested.

    • @CurbalEN
      @CurbalEN  2 года назад

      Mmm it should be there!

  • @chrisc2084
    @chrisc2084 3 года назад +1

    Hi, a great introduction to using MS flow. Did you, or any of your subscribers, come across a 1000 row limit when exporting the data as CSV from PowerBI?

    • @CurbalEN
      @CurbalEN  3 года назад

      Yes, and we don’t know how to fix it yet :(

    • @chrisc2084
      @chrisc2084 3 года назад +1

      @@CurbalEN Thanks for the prompt reply. I will keep searching, If I find the answer I will let you know. Thanks again for help and your posts very helpful. Chris

    • @CurbalEN
      @CurbalEN  3 года назад

      Yes, please!!

    • @sebastiendebosscher
      @sebastiendebosscher 3 года назад +1

      this is really a terrible limit. I put in all the work, and now I have to conclude it's worthless... 1000 row limit is a deal breaker.
      Anyone any solution or work around?

    • @CurbalEN
      @CurbalEN  2 года назад

      I found a way to export up to 100k rows to Excel, check it here:
      ruclips.net/video/WsbIXJDhC_o/видео.html&ab_channel=Curbal

  • @MahmoudSamir7oda
    @MahmoudSamir7oda 2 года назад

    Big thump great features and tool thank you for the clear explanation

  • @Nazman007
    @Nazman007 2 года назад

    Great work, thanks so much... got the PowerBi button to work straight away, your video is so easy to follow !!

  • @Amy-ve3ke
    @Amy-ve3ke 3 года назад

    oh thank god!!! this was missing in the previous PowerBi :) thanks!

  • @ezilore
    @ezilore 2 месяца назад

    Hi! Is there is a way to add a step the flow to direct you to the sharepoint folder / URL and open that link? This is for audience to be able to directed to that folder once they export.

  • @abhishek.bhovad
    @abhishek.bhovad 2 года назад

    Hi, is there any way to truncate a table as it is appending the rows to existing ones.

  • @santiagosanchez6638
    @santiagosanchez6638 2 года назад

    Muchísimas gracias por tu ayuda!!!!!, realmente necesitaba poder cargar los datos a Excel.

  • @sumanthreddy9815
    @sumanthreddy9815 Год назад

    Great video, but is there a way to overwrite the data in the same file whenever we trigger the flow. Instead of creating a new file

  • @mariarazdelkina7920
    @mariarazdelkina7920 3 года назад +1

    Great video as always! Is there an option to name exported csv with it's dynamicly changing header or just dax measure with data selected on slicers? Thanks!

  • @RushiLadani1995
    @RushiLadani1995 Год назад

    Thank you very much! Awesome functionality to have for my self-service report.

  • @wendzbrand
    @wendzbrand 3 месяца назад +1

    "in sharepoint" --might want to add that in the title to avoid confusing viewers and prevent clickbaiting. thanks

  • @DanielWeikert
    @DanielWeikert 3 года назад

    Could you elaborate on which access rights /license users of your report need? They will be the ones using this feature.
    Thx and best regards

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Yes, I should definitely do that!

  • @matiaspaolino6117
    @matiaspaolino6117 3 года назад

    Great addition Ruth! Just wondering when this feature will also be applied for exporting the whole report to PPT

  • @Nrod7
    @Nrod7 3 года назад

    You saved me with this video. Thanks a lot !!!

  • @sarab_2185
    @sarab_2185 3 года назад +1

    Hello Ruth
    Great video, thank you so much.
    I need to build a Power Automate flow, which does the same thing you did(export csv file from Power Bi Repot and put it in a Sharepoint folder) but I need to do it automatically every day without clicking on the button, in short, I need to schedule this flow.
    Can you tell me if it is possible to do this with Power Automate?
    Thank you in advance

    • @martyc5674
      @martyc5674 Год назад

      Hi Sarab - I am looking for the same solution- did you figure out a way to schedule this?

    • @CurbalEN
      @CurbalEN  Год назад +1

      @martyc5674 check the playlist, is all in there :)

  • @efthimiosspiridopoulos9531
    @efthimiosspiridopoulos9531 3 года назад

    Great job Ruth, thank you!
    How can you manage to get a UTF-8 csv though? Having data in other languages is an issue...

    • @CurbalEN
      @CurbalEN  3 года назад

      Yes, it always is :( , same issue with spanish and swedish...

  • @RobertoStaltari
    @RobertoStaltari 3 года назад

    You read my mind! I really need this, Thanks Ruth

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Thank the Power Platform team :)

  • @chrissittenfeld
    @chrissittenfeld 3 года назад +1

    Hola Ruth! Saludos desde Costa Rica, muchas gracias por estos videos tan buenos.
    Será posible extraer automáticamente la data todos los días sin tener que apretar el botón? Se podría usar otro trigger para extraer la data?

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Hola Christian,
      Prueba esto:
      m.ruclips.net/video/VmZUOcUD0qY/видео.html

  • @lindabond9307
    @lindabond9307 2 года назад

    Grazie Ruth! Excellent tutorial.

  • @UU-ry6gt
    @UU-ry6gt 3 года назад

    As usual great job! Pls. keep posting!!!

  • @solarson_studio
    @solarson_studio 3 года назад +1

    Thanks for this great contents - Q: if we have a chart in tooltip, can we use this method to allow the user export the chart? Thanks!

    • @rosaisela06
      @rosaisela06 3 года назад

      I have same question. Did you find solution?

  • @cvalarcon
    @cvalarcon Год назад

    Hi Ruth , thanks 4 the video , but in my case I have a table (in the desktop) with Total rows in all columns , how can you export to excel included the total rows at the end of the table in the excel file ? Thanks

  • @intisabahmad6046
    @intisabahmad6046 3 года назад +1

    Thanks a lot for all the great videos that you post for making our lives easier... I implemented this today and noticed that this flow is only exporting 1000 rows... can u please check on ur side and see if ur facing the same issue? My data has 5000 rows and every time I trigger it I am getting only 1000 rows....

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Yes, I heard the same for somebody else :(

    • @jenniferabell8055
      @jenniferabell8055 2 года назад

      @@CurbalEN Is there a way to get more than 1000 rows out? This is why I usually avoid using Power BI Desktop. It seems so hard to get the clean data out.

    • @CurbalEN
      @CurbalEN  2 года назад

      Not yet :(

    • @CurbalEN
      @CurbalEN  2 года назад

      I found a way to export up to 100k rows to Excel, check it here:
      ruclips.net/video/WsbIXJDhC_o/видео.html&ab_channel=Curbal

  • @oariasz72
    @oariasz72 3 года назад +4

    Hello Ruth, excellent video as always. I am interested in exporting to Excel from a Power BI report button (after filtering and slicing according to user needs) but to a local file. I have read that this is possible using the gateway. Is it possible? Could this work for a public Power BI report embedded in a website? I have looked for a solution to this everywhere with no success. Thank you!

    • @diligent8688
      @diligent8688 Год назад

      Hey - Did you find a solution for this?

    • @davidlee3499
      @davidlee3499 7 месяцев назад

      nope

    • @CurbalEN
      @CurbalEN  7 месяцев назад

      I dont think it works for public reports but you can export to a local folder. Check the export playlist.

  • @georgib0y
    @georgib0y 3 года назад

    Thanks, Ruth! Great video. I have one question, how did manage to get the parameters to appear under the input field? I always get on the side, it is awful.

  • @santhoshreddykesavareddy1078
    @santhoshreddykesavareddy1078 3 года назад +2

    There is already “Export Data” option on a table visual which gives two options CSV or Excel. This work around will store directly in Sharepoint

    • @CatNair
      @CatNair 3 года назад +1

      Unfortunately, export to .csv has a limit of 30K rows and export to excel is not available on PBI Desktop.

  • @orlandoflorida6079
    @orlandoflorida6079 3 года назад

    thaks, is it possible that the end user can export the excel file to his local directory?

  • @nicoymartina
    @nicoymartina 3 года назад

    That was marvelous, Ruth. Thanks!

  • @cleanthisconstantinou7013
    @cleanthisconstantinou7013 3 года назад

    Okay...that was wayyy more exciting than I expected it to be! Kudos to you Ruth! Will you be making a video on how to update existing excel data as well?? Please :)

  • @abbielmi9163
    @abbielmi9163 3 года назад

    Hi nice video. I don't get the step under the add rows into table, i see you select sharepoint and the file name appears . I noticed you mentioned of having the excel alreay created in your drive. In my case i don't have the excel file so i can't see the file name when i select the file option.

  • @lolalola8421
    @lolalola8421 2 года назад

    Very good video!! How to make a button to export to excel but the report have a slicer with many filters?

  • @WenhaoWuuu
    @WenhaoWuuu 3 месяца назад

    this is great, thank you for sharing this tip! However, I'm not seeing the button rendering when I publish my powerBI report to the web. It shows up in my powerbi service though. Do you know if there is any workaround? thank you very much

  • @ksyppo7840
    @ksyppo7840 2 года назад

    Hola Ruth thank for sharing this useful function. I started to follow for my own and did it step by step following your description but i struggle with an error: "The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'" in the "create csv table" part. Any idea or solution. Many thanks Michael

  • @luisfernandomacedo1451
    @luisfernandomacedo1451 2 года назад

    Great video!
    Does anyone know how to get the files formated when exporting to CSV?
    For example: if I have in my table words like "São Paulo, Ceará", they aren't properly formated after exporting to CSV. São Paulo gets like this: S¢o Paulo, and all the words get the same standard.

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 7 месяцев назад

    Any option that array functions could work inside the table as they throw #spill error

  • @annarohacewicz8190
    @annarohacewicz8190 3 года назад +1

    Hi,
    I tried to do that (cvs) and it appears this problem : The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'- In the action create cvs table.
    Do you have any recomendation how to resolve it?

  • @rayjs01
    @rayjs01 3 года назад

    How to handle concurrency in export on excel.When different users click on the export to excel at the same time?

  • @randychen3375
    @randychen3375 Год назад

    Can we setup the schedule the export in customized calendar ? As we know, sometime users would like to see the report in some specific day such as BD1, BD2, and avoid the holiday.
    So it would be great if the export could avoid holiday or happen with a customized calendar.

    • @martyc5674
      @martyc5674 Год назад

      @randychen3375 did you figure this out?- interested in scheduling this exact process for an idea I have.

  • @wouter94
    @wouter94 3 года назад +5

    Right on time. For those wondering: it is possible to export locally, pre-requisit is that you have a gateway setup. Use the create file option under "file system". Downside: you can only export the first 1000 rows. Next video: how to build loops in power automate to export more than 1000 rows at once?

    • @vittoriogiatti
      @vittoriogiatti 3 года назад

      Normally we can download max 30k rows from a visual table. Is it possible to download more in this way?

    • @wouter94
      @wouter94 3 года назад +2

      @@vittoriogiatti I'd say once you understand how to loop through, then yes.

    • @gulhermepereira249
      @gulhermepereira249 3 года назад +1

      Same question here, my users would like to have it locally

    • @CurbalEN
      @CurbalEN  3 года назад +2

      Looking into it. I will do a video if I find out how :)

    • @jeffrey6124
      @jeffrey6124 3 года назад

      @@CurbalEN Please do :-) Thank you in advance

  • @AKssupersan
    @AKssupersan 3 года назад

    Great video, this will help me a lot. I had a question and if I publish it online the button will continue to work and activate my flow?

  • @amitvij07
    @amitvij07 3 года назад

    HI , thank you for video, is there is any way to export the matrix into excel or csv without unpivoting it or without changing the format?
    thank you

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Not that I know of

    • @amitvij07
      @amitvij07 3 года назад

      @@CurbalEN thank you for quick reply

  • @MeIrritaIsso
    @MeIrritaIsso 6 месяцев назад

    You are incredible!

  • @dantepraxedis
    @dantepraxedis 3 года назад

    Can be this incorporate in a Publish to Web report?? that would be an alternative to this limitation. Tks again Ruth

    • @CurbalEN
      @CurbalEN  3 года назад

      I am afraid not :(

  • @sijoaj3578
    @sijoaj3578 3 года назад

    Thank you. Worked out well but Does the export to Csv comes with limitation of 1000 rows??

    • @CurbalEN
      @CurbalEN  3 года назад

      Yes :(

    • @sijoaj3578
      @sijoaj3578 3 года назад

      :) Will a filter/slicer for 1000 rows each can help??

  • @garytouati729
    @garytouati729 3 года назад

    Awesome. So helpful.
    Do do you know if there is a way to avoid cliking on button and replace it by an "automated scheduled task"?

    • @CurbalEN
      @CurbalEN  3 года назад +1

      You can Do that with alerts in power bi service, but it is very limited.
      Example:
      m.ruclips.net/video/ZtBac2tGZTI/видео.html

  • @ElGatoMarcus
    @ElGatoMarcus 2 года назад

    Amazing video again. Thank you!!

  • @hhbadarin
    @hhbadarin 2 года назад

    Super helpful, Thank you!

    • @CurbalEN
      @CurbalEN  2 года назад +1

      Check the newest video if you run into the api limit :)

    • @hhbadarin
      @hhbadarin 2 года назад

      @@CurbalEN I did! Can you share a link to the video?

    • @CurbalEN
      @CurbalEN  2 года назад

      It is the latest one:
      m.ruclips.net/video/fbeMw9jtJB4/видео.html

  • @elrevesyelderecho
    @elrevesyelderecho 3 года назад

    Love you! Bookmark as a favourite! I will watch it later! Thanks!!!

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Pure power platform gold!!

  • @dariom5073
    @dariom5073 3 года назад

    Great feature!
    To use it I need a Power Automate license?

  • @migmanc
    @migmanc 3 года назад +1

    Great video, on CSV example I replaced .csv for .xlsx on file name and work, I got excel file :-)

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Yes, that is possible too, but you got less rows right?

    • @migmanc
      @migmanc 3 года назад

      @@CurbalEN yes, All was rigth

  • @therajbam
    @therajbam 3 года назад

    This is very useful. Thanks. One of my client is asking to generate the csv and email to the group email along with the dashboard page. I am able to generate PDF automatically at 8 am after my dashboard refreshed and then send email. how do I accomplish attaching the CSV file? As per above flow, someone need to click the button on the powerbi dashboard to export.

  • @rosswaterston
    @rosswaterston 3 года назад

    This was a great feature to have added, so often you still get the "I need to be able to have and export of that", filtered, sliced etc... Analyse in Excel is great, but when they want to have the raw data, you used to have to set up a Paginated Report and use parameters to replicate your filters etc... Considering that needs Premium that's not always an option. Using Power Automate is way simpler (and cheaper)!

    • @CurbalEN
      @CurbalEN  3 года назад +1

      Exactly, power automate is just amazing :)

  • @cemtekesin9033
    @cemtekesin9033 3 года назад +1

    Does it work with Publish to web? Thank you for the video!

    • @agathakozlowska4077
      @agathakozlowska4077 3 года назад

      Have you tested already I'm curious too?

    • @stevevincentvilleza1
      @stevevincentvilleza1 3 года назад

      It did not work when I published it. It says error. Hmmm

    • @CurbalEN
      @CurbalEN  3 года назад

      Thinking about it (havent tested yet) it should not work. I think you can not give anonymous access to a flow.

    • @stevevincentvilleza1
      @stevevincentvilleza1 3 года назад

      I think the problem is that the visual is not certified yet and it is not yet added in "My Organization".

    • @CurbalEN
      @CurbalEN  3 года назад

      But how would you give access to users?

  • @mystuffstudy1403
    @mystuffstudy1403 3 года назад

    Good Explanation, can we cross the limit in power bi for export which is 150k rows ? Any other workaround for crossing the rows limit.

    • @CurbalEN
      @CurbalEN  3 года назад

      R or dax studio. I have a link in the pinned comment

  • @seanvsn
    @seanvsn 2 года назад

    Hello, about the Excel Export Button, do i need a PBI Licence + an Excel Online (Business) licence only to set up the button, or do simple users need that as well?
    My customer strictly requires this feature with a specific button, but since i'm not provided with a Business Excel Licence to attempt some testing, i am a bit stuck in the middle.
    Thank you!

  • @srinathkaithoju4087
    @srinathkaithoju4087 11 месяцев назад

    Hi, i have a report with multiple tabs and would want a Power Automate flow to export Power BI report tabs to individual worksheets in a workbook. need your help

  • @aniketshukla8967
    @aniketshukla8967 2 года назад

    Is this going to work on the filters that we selected as well?

  • @rashmirao4038
    @rashmirao4038 4 месяца назад

    Hi, How do we export the file into our local Downloads folder?

  • @Datani_ecuador
    @Datani_ecuador 10 месяцев назад

    Se puede exportar una tabla de power bi a excel manteniendo los colores de los encabezados y filas.

  • @rakshithbukkit4802
    @rakshithbukkit4802 3 года назад

    Nice video. Can we create a button on the report when end-user clicks, exports report to pdf and email with the help of flow?

    • @CurbalEN
      @CurbalEN  3 года назад

      There is a button for that already on the service and desktop

    • @rakshithbukkit4802
      @rakshithbukkit4802 3 года назад

      @@CurbalEN yes but we need it on the report. we are embedding the report in SharePoint. End-user can directly use that button to export a report to pdf, Is that possible?

    • @CurbalEN
      @CurbalEN  3 года назад

      If you have premium, you can use export to pdf in power automate, otherwise you can do something like this:
      m.ruclips.net/video/DwopZzus24E/видео.html

  • @taglud
    @taglud 2 года назад

    hello, please i would like to know which application do you use to be able to do such video. do you have a green wall behind you or the application does all the work ? thank you

    • @CurbalEN
      @CurbalEN  2 года назад

      I have a green screen

  • @SunilKRoge
    @SunilKRoge 3 года назад

    Hey Ruth, export to CSV doesn't consider visual level filter. Can you suggest any easy workaround? Since I want to filter on a measure, slicer is not an option.

  • @jin0616
    @jin0616 6 месяцев назад

    Hello, with your example, all the headers are at the top of the row, but I would like to have it like a matrix format, some of the headers on the left side and also, the headers on the top are years value which are the values from one of the power bi table so that depending on the filters on the page, the number of columns could be different. (e.g. 2020, 2021, 2022 or could be 2021,2022) how can I make that work? at the moment, the flow extract exports like normal standard export which has all the headers at the top

  • @geoffdomal5155
    @geoffdomal5155 Год назад

    Wow, this is so cool. Thank you!

  • @yiyiwang8861
    @yiyiwang8861 Год назад

    This is great! Could you also share how to export the table in powerbi BI?

  • @josefinagaccio2362
    @josefinagaccio2362 2 года назад

    hi!! How can I trigger the flow automatically without clicking the button? I need to schedule this flow to run once a week automatically

  • @Howard_Martinez
    @Howard_Martinez 2 года назад

    Hi, how could i compare table with a condition to add or update row?