Power Automate get data from Power BI dataset Revisited

  Рет қаралды 16,393

Hat Full Of Data

Hat Full Of Data

Күн бұрын

Пікірлер: 44
@pbiqueryous
@pbiqueryous 11 ай бұрын
The most important video of our PowerBI times, saving lives! This is amazing!
@michelenarvaez9271
@michelenarvaez9271 11 ай бұрын
BLESS YOU! I have been trying for DAYS to get my large payload Parse JSON to work (the dynamic content wouldn't popular the columns). I have googled and tried multiple ways. Your video finally helped me! That Compose before the Parse JSON saved me! Thank you for posting this! 😃
@HatFullOfData123
@HatFullOfData123 11 ай бұрын
Compose action saves me so many mess
@Alan-ps2ul
@Alan-ps2ul 7 ай бұрын
Thank you - the 1st 'Compose' to generate JSON Schema has solved a problem I have spent the past 3 days working on and getting nowhere. This is such a great way to get working Schema and better than I've seen elsewhere on KZbin!
@HatFullOfData123
@HatFullOfData123 7 ай бұрын
Compose rescues me soooo many times
@katrockhold2791
@katrockhold2791 Жыл бұрын
Thank you so much! This video helped fix two of my issues. I even enlisted the support of a Power Automate expert within my company and we did not achieve the targeted result. This video helped me greatly!
@SoumenGhoshal
@SoumenGhoshal 11 ай бұрын
Great point. Special characters were a trouble. Also the query needs to memory efficient. Excellent video.
@rauljimenez5485
@rauljimenez5485 Жыл бұрын
Some nice gold nuggets in there, the parse and formatting of the output of the HTML table are simple yet very powerful, thank you for sharing!!
@berggrog1
@berggrog1 Жыл бұрын
That was really a good video. Simple and easy to follow. You do a very good job presenting stuff in an easy manner. Keep up the good work!
@kitchugeths
@kitchugeths 8 күн бұрын
Great content! Really helped me to start a new flow and automate! Thanks a lot
@careyjohnson6630
@careyjohnson6630 9 ай бұрын
One of the all-time greats. 5 stars!
@venkatr4972
@venkatr4972 7 ай бұрын
You're my Savior.. Thanks much . please post more update format in Expression
@RyanOlexa
@RyanOlexa 3 ай бұрын
This was sooooo helpful! Thanks so much!
@sjwendell
@sjwendell 3 ай бұрын
That paste DAX as plain text really helped! Power Automate would not provide a specific error as to what was wrong, just an invalid expression.
@HatFullOfData123
@HatFullOfData123 3 ай бұрын
It had me confused for ages
@manassehkisame6286
@manassehkisame6286 20 күн бұрын
This was a life saver!
@wadanda
@wadanda 10 ай бұрын
Excellent video!
@HatFullOfData123
@HatFullOfData123 10 ай бұрын
Glad you liked it!
@bangerasiddharth
@bangerasiddharth 2 ай бұрын
Helpful, thanks.
@1yyymmmddd
@1yyymmmddd 3 ай бұрын
Great tutorial. Can Power Automate handle complex queries? Does it support all DAX functions?
@JannievanderWalt
@JannievanderWalt 11 ай бұрын
Awesome video, interestingly, I followed your first video where I copy the DAX from the Performance Analyzer where in PBI Desktop the Table has only one column and +-7000 entries. However when Power Automate Processes it, it only processes 501. Changing the DAX in the way how you did it in the DAX Query View (New feature in PBI Desktop) its shorter and simpler to read and now Power Automate processes it properly for all 7000 records. It's weird... but thank you this video also helped me understand the Parse JSON bit and I like how how you simplify the JSON by grabbing it from the Compose and not just any output... and now I know how to rename the columns at the end. 🙏🙏🙏🙏🙏🙏
@HatFullOfData123
@HatFullOfData123 11 ай бұрын
Glad it helped!
@gthornbu
@gthornbu 9 ай бұрын
There is actually a simple solution to this problem. The old method using the performance analyzer sometimes adds a top n filter to the table with the limit of 501. You can find the filter in the dax query and change it to a higher number or delete it to fix it. The dax for the top n is TOPN(501, 'your table')
@MarcusCrutchfield
@MarcusCrutchfield 9 ай бұрын
This video is extremely helpful! THANK YOU! I'm just wondering if there's a reason you keep the 'Compose' data operation before the 'Parse JSON'? would the flow still work without it?
@HatFullOfData123
@HatFullOfData123 9 ай бұрын
You can get rid of it as we don't refer to it. Good point!
@MrTC-rv3jo
@MrTC-rv3jo 6 ай бұрын
Great video! I searched a lot for something like this! thank you! My only issue is that I need to send a scheduled email with a CSV file containing the data in a table format. I was able to do that but I got the CSV file to show me the data in the first row only and not as a table with headers and columns. Any idea on how to overcome this? thanks again!
@Bananaskin1
@Bananaskin1 10 ай бұрын
Has the Dax feature been removed? I am running the Feb 2024 release and I'm only seeing the standard 3 options.
@Bananaskin1
@Bananaskin1 10 ай бұрын
Forget my previous question, I hadn't realised that there was a preview features facility
@valapo80800
@valapo80800 10 ай бұрын
keep cool!!!! keep cool!!!
@gabrielemannoni4668
@gabrielemannoni4668 5 ай бұрын
Bravissima!!!
@rundvi
@rundvi Ай бұрын
Thank you
@mirrrvelll5164
@mirrrvelll5164 6 ай бұрын
Very useful video. Does it apply on daily refresh? I mean I tried similar to your method but I am still getting the data from yesterday, so it repeats me the "old schema" basically. How to make that dynamic?
@HatFullOfData123
@HatFullOfData123 6 ай бұрын
If the semantic model is refreshed the data fetched should be refreshed. How are you specifying your date range in the DAX?
@mirrrvelll5164
@mirrrvelll5164 6 ай бұрын
​@@HatFullOfData123 Ah I checked the query in PA, and found that has been filtered on yesterdays date. So I built like IsToday on visual, saved it with new query and added this step in query. But I removed it afterwards (isToday) because the visual should be dynamic.. Do you think it will work tomorow wih new data`, or better question, is there an additional step in PA for like checking for todays date?
@HatFullOfData123
@HatFullOfData123 6 ай бұрын
Making the DAX dynamic is the best way.
@sujatarao9913
@sujatarao9913 10 ай бұрын
Hi, I need to write table visual data from powerbi to sql server via power automate , how can I do that ?
@DanieleGrossiCiccone
@DanieleGrossiCiccone 9 ай бұрын
you saved me, thank you
@HatFullOfData123
@HatFullOfData123 9 ай бұрын
Glad it helped!
@sofianeboukecha
@sofianeboukecha 11 ай бұрын
great video, thank you can we do the same thing to extract an XLSX file, not HTML table?
@HatFullOfData123
@HatFullOfData123 11 ай бұрын
Once you have the data from the query you can do what you like including adding to an Excel table. Making a new table is a little more complex
@sofianeboukecha
@sofianeboukecha 11 ай бұрын
After the Json step?
@kumarhrithikranjan1788
@kumarhrithikranjan1788 Жыл бұрын
Do we need PowerBi capability licence or will the per user can do the work and do we need paid Power Automate licence for this?
@kumarhrithikranjan1788
@kumarhrithikranjan1788 Жыл бұрын
Capacity*
@HatFullOfData123
@HatFullOfData123 Жыл бұрын
You will need access to the dataset so you will need pro Power BI licence minimum. It's not a premium connector in Power Automate so just a free license will work.
Extract Power BI data & measures with Power Automate
17:15
Access Analytic
Рет қаралды 9 М.
Жездуха 42-серия
29:26
Million Show
Рет қаралды 2,6 МЛН
The Best KPI Cards In Power BI
40:17
Power BI Park
Рет қаралды 56 М.
Copy Power BI Data to SharePoint List with Power Automate - Easy Guide
11:29
Power Automate get data from Power BI dataset
6:53
Hat Full Of Data
Рет қаралды 52 М.
Case Study - Adding Data From Power BI Report to Excel Using Power Automate
28:21
Jason Davidson (Power BI)
Рет қаралды 26 М.
Differences between GROUPBY and SUMMARIZE
28:30
SQLBI
Рет қаралды 42 М.
Power Automate button in a Power BI report
7:10
Hat Full Of Data
Рет қаралды 9 М.