SCHEDULE Exports from Power BI AUTOMATICALLY // Power Automate to SharePoint Folder Data Exports

Подписаться 49 тыс.

Просмотров 73 тыс.

50% 1

In this video were going to go through how you can use Power Automate to export data from Power BI reports.
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solu...
solutionsabroa...
❤ Other ways to support
ko-fi.com/solu...
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 122

@rickcoterie5700 Год назад

FAST WORKAROUND FOR ALL OF YOU - 1. In PBI create a raw table with data, no title, not matrix view, add all the columns you want from tables, measures, etc. 2. PBI click View at the top then Performance Analyzer 3. Then Refresh Visuals 4. Select your table in the list and expand it with the + symbol in the performance analyzer window 5. Click Copy query and paste that into your Power Automate query text section Done :)

@nagarjunaambati3141 Год назад

Man. Who the Fuck are you. You don't know how much good you did today. Thank you.

@rickcoterie5700 Год назад

@@nagarjunaambati3141 you are welcome lol.

@GIbrAvila Год назад

Just came back to say thank you. You're the man

@rickcoterie5700 Год назад

@@GIbrAvila I have been using this method recently to also create complex DAX. Add your filters to the table, etc. Then run performance analyzer and grab the code, copy paste and modify... Great stuff and glad I could help!

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

@@rickcoterie5700 how much do you modify and what? I keep getting errors when copy pasting the complete formula

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

Thanks a lot for the information provided, I have one inquire. Could I export the data in an XLSX format instead of CSV, and how?

@zpakk4499 Год назад

Instead of rewriting the whole table, you could just go to Performance Anlyzer, start Recording, copy query, then paste into Power Automate query text. Done.

@SolutionsAbroad Год назад

That's a great solution! I think this is also a good alternative if you don't have access to Power BI Desktop

@veryphiil Год назад

Is there a way to format the headers in the csv file automatically within Power Automate to not have the square brackets?

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

I am facing the same issue. Have you got it?

@thetouristlives Год назад

Just a heads up, this approach still suffers from truncated exports. An approach I've gone for is to identify what columns I can partition my data on, and then iterate over those partitions doing smaller exports that I am confident will be under 1000 rows (although it's not strictly 1000 rows, lots of columns also factor into it).

@indranildas_55_a70 Год назад

How to remove those brackets at the column name while automating the process.

@gauravramchandani3832 2 месяца назад

Hi @indranildas_55_a70 add in extra 2 steps into your flow with Replace command. It should look something like this: Replace(output/powerbi first row column, ‘text you want to replace’, ‘’) Repeat this 2 times first for start of the bracket then second for end of the bracket. And use output from second compose to create csv.

@alanprice7884 Год назад

Names in each of the csv file header columns are transferred within square brackets [ ], is there anyway of changing this so the header names are not in brackets?

@SolutionsAbroad Год назад

That's a great one, I'm not sure but let me come back to you on that

@Timhoste Год назад

@@SolutionsAbroad did you find a solution ?

@puralupe8781 17 дней назад

Great video and clear. It REQUIRES access to the workspace of the PBI report, however. I have many reports where I have read access in Cloud PBI but I do have access to the Workspace. How do I automate export from a PBI report without Workspace access?

@richaduggu471 Год назад

I tried but more than 100K data not exporting ,

@priyavishalkulkarni2415 Год назад

How can we export data from Power BI to Excel automatically and send it to the client through the mail using scheduling?

@dksadiq 5 дней назад

Thanks a lot for the information Fernan! Really useful and much appreciated!

@kazukoimamura4931 2 месяца назад

I am so impressed. CSV file's field names has []. I would like to remove these symbols. How shall I do?

@StanOlbrot Месяц назад

I new version on Power BI Desktop is a Work with DAX query view funcionality where is possiblity to create and evaluate dax code . After that you can copy query to flow

@chengwang411 2 месяца назад

seems texts in languages other than English will be return error in CSV. can fix? /(ㄒoㄒ)/~~

@natalia838383 Год назад

Hi, do you you know if we can get rid of the [ ] on the header? thank you

@SolutionsAbroad Год назад

Hi Natalia, I'm not sure but I will have a look and let you know!

@natalia838383 Год назад

@@SolutionsAbroad thank you :)

@mehdiabdellaoui5458 Год назад

I have the same issue, did you solve it ?

@joserobertodantas1516 Год назад

Nice video! Does anyone know if it's possible to export like this from Power BI filtering from [Order Date] just by values corresponding to the current year and month (or the previous month)?

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

see my comment above. Should cover what you needed if you didn't solve it already. In the filters add your specific dates and do what I listed above to get the code.

@RenitaDsilva-b9e 3 месяца назад

I want to be able to export data from my PowerBi to Google sheets directly without having to save in excel and then paste in Google sheets. Can you share a process that would help in automating this and if you could share it on your channel it would be helpful.

@pallavi_joseph 4 месяца назад

Hi I tried exporting a table with 20000 lines . This method returned only 14000 lines

@joseignaciofarias6564 Год назад

Wow Fernan! Thank you very much, your explanation and video helped me a lot. I just have one question, how do I query 4 tables? because I tried generating 4 separate queries and it works. But I would like those 4 tables to be together so I can send them by mail! Thanks You!

@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, etc..and avoid the holiday. So it would be great if the export could avoid holiday or happen with a customized calendar.

@חייםחדד-ח2מ 6 месяцев назад

This is not relevant for most organizations. Show us how to do it as scheduled flow and not by pressed button !!

@pavankumarreddy743 3 месяца назад

Can we get json data file from pbi datasets through power automate

@PawanKumar-nh3pi 4 месяца назад

How to use the power automate action - "export to file for a paginated report"

@prachikanoongo1221 2 месяца назад

I want to export all data from the table automatically, how to do that?

@alejandrogranados8104 4 месяца назад

this will also give the latest data export from power bi service?

@madinachady5258 Месяц назад

how to remove the bracket [ ] in the header column

@potter0729 Год назад

Hello, I currently have a Visualization (table) within a dashboard in Power BI Service that captures the snapshot of live data each day (via incremental refresh). However, I figured that when I follow your steps, the "Run a query against a dataset" always seem to cause an issue. Is there a way for me to auto-export those incremental refreshed results that are in the dashboard in Power BI Service?

@sanketchakane7745 4 месяца назад

max data downloaded is 100000 in csv using this

@olenadumna4206 11 дней назад

Thanks a lot for this video !

@gatiendeniaud9089 Год назад

Nice video ! But when I tested my Power Automate I have an error : "{ "error": { "code": "PowerBIFeatureDisabled", "pbi.error": { "code": "PowerBIFeatureDisabled", "parameters": {}, "details": [ { "code": "DetailsMessage", "detail": { "type": 1, "value": "'DatasetExecuteQueries' is not enabled for the tenant." } } ], "exceptionCulprit": 1 } } }"

@SolutionsAbroad Год назад

Thanks for watching! From that error it looks like your tenant admin has disabled this feature, try to speak with your IT Admin (if you have one) and they should be able to help you

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

How can I format the dates in my table?

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

How to remove T and format Order Date in date column?

@momo70467 Год назад

I am actually trying to export the data of a report (specific visual : table, not all other parts of the report) in PBI service into excel and email it directly to the asking person using power automate but it keeps failing or sending an email without an attachment! I really need help please

@ewajakubowicz8497 Год назад

Hi :) Did you figure it out maybe? It seems like the same case I'm working on now and trying to find a working solution :)

@andrewfoncette5231 Месяц назад

Nice video. What if I wanted to schedule exports from Power BI automatically to a SharePoint List instead?

@marcelocabral5096 Год назад

saved my day , tks :)

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

Thank you for the video, but I have one question: When I do create this flow the same way you did (step by step) the .csv file will display my data in just one column, even though the original table has multiple columns. How can I fix this? Thank you for your help!

@carlosgomez-df9cg 8 месяцев назад

Amazing.. this video helped me a lot. thanks.. I have a question.. I use the command CALCULATABLE in the query and I need the data Sorted. Somebody know how generate it sorted?.. thanks in advance

@aviator172rr Месяц назад

This is a great tutorial! Question: How can I set up a schedule to export data to the same file in Power BI, ensuring that new data is appended to the existing file rather than updating it? I want to avoid losing any previously extracted data that may no longer be present in the original source.

@shaibeezz 9 месяцев назад

Hi, Question: what if I need to export the data in multiple Excel (xlsx) files, e.g. I have sales data by 'Locations' and 'Sales Person,' and I need Flow/PowerAutomate to create a separate file for each Location and Sales Person.

@jonathansanchez4636 Год назад

I am only getting some of the records, my current table has around 74,000 rows but only about 21k+ are being added to the CSV file why?

@AshishSingh-tw2vd Год назад

In dax studio, after running the query i am getting 33,000 rows but, when i pasted the same query in automate in csv file only getting 4,000 rows. How is this possible? I am stuck, please help

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

Hi Fernan, can we do this for Usage metrics report as well? If yes, could you briefly paste the solution for reference?

@bhaveshpattani3343 Год назад

If we want flow to gives us output to specific duration say last 7 days only, how to do that, as we are coping query from PowerBI directly which has date range and power automate does not change date dynamically

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

Very good video - Is there a way to create a Scheduled Flow that runs once a month and exports Power BI data to XLSX file? As of now I can only do that using a button alternatively if I create a Schedules flow I can only export the data in this manner you showcase here but need XLSX format.

@050224011 2 года назад

I’ve needed to be able to do this for sooo long. Thanks so much!

@VisionAstrology1985 Год назад

Thanks It worked but it do not return all records from PBI... i tried all methods... is there any alternate way

@natalia838383 Год назад

Hi, do you know if i did something wrong, when i run the flow, its error as the file.csv already created. You had mentioned if file exists it will overwrite the old file. is this correct? thank you

@nagendhrarao5763 Год назад

Can we export the Matrix Visual from Power BI/Power Bi report builder into share point automatically?

@kurcel52 Год назад

If we use this approach we cannot overwrite. Next day it does not overwrite at all as the file is with the same name. And when you test it shows the error of having same file name

@mmbcampus Год назад

How I can export data in excel from power bi app using power automate??

@mmbcampus Год назад

Is there any way to export data in excel from PowerPoint app online with power automate??

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

this will also give the latest data export from power bi service?

@anuragsingh711 Год назад

This is also exporting limited number of rows only

@johanlegernes7279 Год назад

Is this possible to do with dynamic RLS as well? :)

@andrevaz3546 Год назад

Hi thanks, however file is limited to ~7000 rows

@danielam.guerron3576 Год назад

How many times per day could I run this flow?

@jananijanani6674 Год назад

If the report contains two pages how we can export in csv and the thing in a single csv file two pages have to be attached

@rajshekhard Год назад

Thank you very much. Amazing video! Helped to solve my current problem.

@aydeediaz2307 Год назад

Hi, How many rows are allowed to export with this option?

@alexnest4150 Год назад

Thank you so much! It helped me at work a lot! Best of luck with channel promotion!🎉😊

@rjmplq Год назад

Hi. If I wanted the trigger to be based on the dataset refresh timing, how would I do that?

@nadeemrajabali3166 Год назад

Great video. Thank you. I have a table visual that shows all outstanding orders line by line. Along with Requesters name and his/her email address. Is it possible to create a flow where email is sent to every order requester with a list of all outstanding orders lines I have in my visual? it's kind of mail merge but with a table of all outstanding orders line by line.

@nana19tij Год назад

Is it possible to export measures as well? Or only columns? Thanks

@skizofred3 Год назад

Nice video ! Thanks ! Do someone know if there is a way to convert dates format to DDMMYYYY instead of the default ISO format in the CSV file? For example 29/11/2017 instead of 2017-11-29T19:13:17.5844778

@skizofred3 Год назад

Only use the DAX function FORMAT in your query

@RadhikaKnittingstation Год назад

Great knowledge 👍 Your videos are very helpful. Thanks

@joshuaprets2044 Год назад

So you have to use DAX in the Query Text prompt? You can't just refer to a table created by Power Query? Thanks.

@gauravramchandani3832 2 месяца назад

You can, just right Evaluate and all the columns you have in power query table and you are good to go.

@anuragsingh711 Год назад

can we export measures column aa well

@DanielWeikert 2 года назад

Is first table rows unlimited? br

@thing72 Год назад

sadly it does not overwrite fille as you mention @10:46 but it gives me error A file with the name "xxxx.csv" already exists .

@rajendrakulkarni2186 Год назад

I am also facing the same issue . I want to publish back the previous data every week to know the changes. Is there any other way this can be achieved

@Thoth0Amon Год назад

This is the best thing since sliced bread.

@JaredThomas-k8q Год назад

Show how to get into xlsx or xlsm.

@trevorknorpp5335 Год назад

Boss is very happy with me after using this tutorial. Thank you!!!

@PrakashNagaraj1993 Год назад

helpfull.. great video

@LucasAraujo-wk6hj 6 месяцев назад

Your tutorial very good i am from Brazil. Thank you!!!

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

this will also give the latest data export from power bi service?

@050224011 Год назад

I can confirm this works

@ThamerAffara 9 месяцев назад

Great job! Thank you!

@jojojo-9566 Год назад

After running the query against the dataset, is there a way to use that info to populate a SharePoint list (rather than turning it into a CSV and putting it in a SharePoint folder)?

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

Haven't seen an answer to this query - would be really helpful if anyone knows? It seems possible to populate an SPO list using a PowerAutomate button in PBI to export to an SPO list but no obvious way todo if its a scheduled export

@zzota Год назад

Very good, thank you.

@Alex-rm4wh Год назад

Is this for free?

@alexpareja6641 Год назад

This is brilliant, thank you!

@JohnSullivan1 2 года назад

Great video! Thank you!

@bhapapathvisutvatanasak9329 9 месяцев назад

Flow ""run a query against a dataset 4:25

@bhapapathvisutvatanasak9329 9 месяцев назад

13:11 filter function

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

Thanks!

@sarakhosravi921 Год назад

Thanks Great!

@lexrobe_fly 2 года назад

Love it, thanks!

@MG-217 Год назад

Great video, a question please: how do run it with "Dynamic slicers/filters" because each time the user may change the inputs so i need the query to be more "dynamic" how to do that ?

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

Still awaiting for same 😢

@juliansihas1234 Год назад

Great Video!! is there a way to export the table and email as an excel attachment on a scheduled basis?

@JP-dt8em Год назад

Yes we can do just add Send an Email Step

@АйнурКенжегулова-и9с Год назад

Thank you so much. Easy explanation 💯

@tolulopeesho8103 Год назад

Nice work Fernan, I enjoyed the video as always, but please when i tried to run my flow i got the following error {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (14, 1) The syntax for 'Evaluate' is incorrect. (Define VAR _table = SelectColumns( \t'MetricsProjects' \t,\"Project #\", 'MetricsProjects'[Project # Full] \t, \"Delivery Manager\", 'MetricsProjects'[Delivery Manager] \t, \"Project Region\", 'MetricsProjects'[ProjectList.Region] \t, \"PO #\", RELATED('Unreceived'[DocNum]) \t, \"Line #\", RELATED('Unreceived'[L#]) \t, \"Exp Type\", RELATED('PMO TaskGroup'[Exp Type]) \t, \"Vendor\", RELATED('Unreceived'[Vendor] \t, \"Missing OLR\", [Latest Missing OLR] \t, \"Days\", RELATED('Unreceived'[Days Old]) ) Evaluate _table)."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3238920194"}}]}}} Please what have I done wrong?