Power Automate get data from Power BI dataset

[@MichaelPrice-x4j]

I came on line to find this EXACT requirement, and find it from the woman that taught me power bi. I'd call that a successful day Mrs GB

[@urbatin9355]

I struggled for a week trying to get 1 flow to work and less than 5 minutes into a video you made this so easy. THANK YOU!

[@HatFullOfData123]

Thank you. It's what I try to do

[@SoumenGhoshal]

These steps are not working. Running a query using power bi dataset results in an empty table and further steps don't execute.

[@markyeap6123]

How do I automatically send an email to show only new rows of data after table visual updates since the last refresh date?

[@HatFullOfData123]

Writing the dax for that would be the challenge.

[@markyeap6123]

Do you have any references?

[@anandreddy2992]

hi thanks for the video, but this method has a limitation of rows, how to import all the rows into a csv table & then place it in one drive/sharepoint, I have already tried the mentioned flow but not getting all the rows in my csv.

[@HatFullOfData123]

Yes it has a limitation on the row count. It's not a tool for doing large extracts

[@nicholasteasdale9733]

would it be harder to create a excel workbook that would keep all data appended each week/month?

[@Bananakillaaa]

I have been struggly hard to get the DAX query. Your video has been life-saving! Thx

[@HatFullOfData123]

Great to hear!

[@SS-lv8pn]

I was wondering if below scenario is possible with power Automate or not ?? Let's say if we want cross report slicer sync in power bi , this feature is currently not available in PBI , is it achievable using Power Automate

[@nataschalaros418]

Thanks! Is it also possible to further specify the email list based on the dataset in the report? Eg. dataset Data Quality + related buyers: send only data of each specific buyer to related buyer email?

[@johntwohig6106]

Thank You! That opens up so many possibilities that wouldn't be possible trying to connect to the data in Power Automate.

[@HatFullOfData123]

Glad to help!

[@KellseaGeers]

Can you help advise how you would clean up the row headers from the HTML table? Thank you!

[@HatFullOfData123]

I'd recommend adding a parse json step after the get data and then look at the advanced step of create table and it gives options to rename the columns.

[@anuragsingh711]

can you please refer me to some documents please

[@BadHoneyBadger]

You are my new best friend. First excellent explanation of this process I have found. Thank you so much.

[@HatFullOfData123]

Glad you liked it. I revisited this topic to rename the columns and make it pretty kzbin.info/www/bejne/eKqspWWeatJniZI

[@jhonmedinahuanacomedina7208]

Hola, no viene al tema del video pero, como puedo cambiar el interfaza de panel de informe, veo el area de trabajo es amplia y los iconos son pequeños. Gracias

[@ritamgiri5872]

So, I came across a requirement to establish that I have to do the same thing except sending the data into a mail, I have to to add a new row to a dataverse table. Do you think is it doable?

[@harshchovatiya-gh7hn]

my data output is coming in one row instead of table ... can you please guide?

[@HatFullOfData123]

Have you just selected measures? What's the DAX?

[@harshchovatiya-gh7hn]

@@HatFullOfData123 its work now. Accidently I Select wrong DB or something. But its ok now, Thanks.

[@poonamk8335]

Instead of sending email step, how to take this data and copy to a dataverse table? any video is available for that? please help. thank you

[@HatFullOfData123]

One method would be to use an apply to each step to loop through all the rows and use an add item to dataverse. If it is huge number of records there might be better methods

[@yadukrishnankv5265]

Thank you for the video @Hat Full of Data! Would I be able to query each column separately using this method and paste into a SharePoint list? Thank you!

[@CigarDoug]

Simple answer: Create a different visual with just one column, and copy that query to your Flow. Repeat for each column. Better answer: Create a query from a table with all of your columns, and manually edit that query to only return the column you want. If you try the simple and understand what the query is saying, you can figure out the better.

[@momochan5963]

Hi, I've been watching your vids for a while and I'm quite curious how you put the composed data into excel file instead of an HTML table?

[@bc67]

Hello. I have hyperlinked text in a Power BI table visualization that I’d like to bring in to Power Automate and then include in an email while preserving the clickable links. Do you know if that’s possible?

[@HatFullOfData123]

Yes I think so. You'll need to build a html tag hyperlink. So you'll need the url as part of the data.

[@adamphaneuf4618]

Hi ! It seems like I don't have power BI in the section "choose an operation". Do you have any idea how I could had it ? Thanks

[@HatFullOfData123]

I have no idea. Power BI can't be blocked and doesn't need a premium license. You on a GCC tenancy?

[@TheKwattK]

Can you make a video or comment how to format the table? I am stuck on this. My table has several columns and shows a lot of brackets and Column names that will not be familiar to the user.

[@HatFullOfData123]

Already done. Take a look at this video and see if it helps kzbin.info/www/bejne/eKqspWWeatJniZIsi=7Dqs3qc01DliCd4I

[@TheKwattK]

@@HatFullOfData123 Got it thank you so much!!!

[@TejinderSingh-es9wh]

Thanks, This is the only way I found to solve my problem of PowerBi limiting only one data alert per hour.

[@HatFullOfData123]

Yes alert is very limited in what it can do.

[@explorer-s1s]

What permissions do we require on the powerbi dataset to be able to query from power automate?

[@HatFullOfData123]

Access to the dataset, so visitor won't work, contributor upwards will.

[@explorer-s1s]

@@HatFullOfData123 is there any way to be able to query the cube data with only read access?

[@HatFullOfData123]

@@explorer-s1s I don't think so but I will have a play

[@kdatany1]

Amazing, thank you! Is there a way to update or rename the header name of the generated table?

[@HatFullOfData123]

Yes there is. I'm prepping a revised video showing the rename

[@tyopapsgaming3471]

how to make it dynamic? tried this flow however, whenever I refresh the Powerbi data, it only captures sa data prior to refresh

[@HatFullOfData123]

Are you refreshing the dataset in the same flow? If you are the refresh a dataset action just starts the refresh and doesn't wait for it to complete.

[@razibhasan1845]

Hi Laura! Firstly, thank you so much for this awesome video. It explained the whole concept in a very lucid manner. Really appreciate it. Now, I have a question. Say, I want to automate the whole process for different filters (-30 to 30) and save those tables according to the applied filter names. How should I approach? Thanks in advance.

[@HatFullOfData123]

I would have a list of the different parameters maybe in an Excel list. Then use a for each to loop through them using a concatenate to create the query to send the queries. And then save the output as csv files. Hope that makes sense

[@vkings512]

Excellent tutorial, the query part is really hidden so thanks for clearing it up

[@ivanarango4973]

Im trying to append the extracted data into an excel but it always ends up adding 1 empty row. Anyone can help me?

[@HatFullOfData123]

You looping through adding rows? Is the blank row on the top or bottom?

[@alexwalker7023]

Hi Laura, is there any way of doing exactly the same thing but to an excel table instead of email? I have some data in excel that needs to have live feed of data that comes from power bi table just like the one in your video, the powerbi data comes from a direct query so I can't edit it in power query unfortunately 😕 thanks, Alex.

[@HatFullOfData123]

Would a CSV file be okay? that's easy

[@niravparmar6545]

@@HatFullOfData123 Hey, Thanks for the video. How can I add .CSV file to the email instead of an HTML table.

[@johns8903]

A bit under whelmed -what good it is, sending a few html records. Pls talk about sending 10s of thousands of records as an Excel file or csv or pdf attachment. Thanks

[@HatFullOfData123]

Sending a quick update to a manager as a teams message is a regular request. If you are handling 10s thousands of records you could save as csv as an action but Power Automate is not the best tool to handle large record counts. It is not a Data Integration tool. Azure Data Factory, Fabric or other options would be better suited in my opinion.

[@amberlylindgren9110]

So my Power Automate does not like my offset field. I continue to get "Column cannot be found or may not be used in this expression." If you ran across this issue please let me know and found a solve I would be tremendously grateful for the assist. Thank you.

[@amberlylindgren9110]

I solved my problem. For anyone else who may run into this problem fields must be published to service before they can be pulled in the query.

[@HatFullOfData123]

@amberlylindgren9110 well done for fixing this

[@jean-christophehoule3669]

Hello, great video. Instead of sending an email, I'd like to move the content gathered from the query to a sharepoint list. Do you think its something fesable? If so, any documentation that you can share that would help me?

[@felixsaint-gelais-nault3028]

Do a compose on your data, see how it's formatted and use it from there

[@AnhNgoc-tr6yp]

Thank you very much. This video is really simple and easy to understand

[@danny1206ec]

Thanks for your sharing. I am struggling on the DAX query and the video is really helpful for me.

[@HatFullOfData123]

Glad it helped

[@Milhouse77BS]

thanks, and you can test RLS for the query also. Nice demo.

[@berggrog1]

Nice work. Simple video that shows a simple solution nicely explained. Thank you!

[@HatFullOfData123]

Last week I did an updated version with a few more extras

[@zerobars3]

Great Tutorial, well explained. Thanks

[@HatFullOfData123]

Glad it was helpful!

[@saharaharris]

Fantastic tutorial - thanks!

[@tomr9969]

Nice! Thanks for sharing!

[@HatFullOfData123]

Thanks for watching!

[@KatieHoke]

so helpful! thank you!

[@l.andreamolinalozano2196]

thank you! your video is amazing 😃

[@capitanmandril]

Thank you very much

[@PavelRamirez-v9v]

thanks! it was helpfull

[@careyjohnson6630]

You da best

[@HatFullOfData123]

Thank you!

[@davidarbuckle9636]

Excellent - But - what an overly complicated application Power BI is. Bring back Microsoft access, that was so much more User friendly!!

[@HatFullOfData123]

I think you are forgetting the oddities of Access which I loved working with. Both have their strengths, quirks and delights.

[@sheshikumarausheni9428]

That's a very useful video Can me make same to send in watsup group user