The most important video of our PowerBI times, saving lives! This is amazing!
@michelenarvaez927111 ай бұрын
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! 😃
@HatFullOfData12311 ай бұрын
Compose action saves me so many mess
@Alan-ps2ul7 ай бұрын
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!
@HatFullOfData1237 ай бұрын
Compose rescues me soooo many times
@SoumenGhoshal11 ай бұрын
Great point. Special characters were a trouble. Also the query needs to memory efficient. Excellent video.
@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!
@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 Жыл бұрын
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!
@kitchugeths7 күн бұрын
Great content! Really helped me to start a new flow and automate! Thanks a lot
@careyjohnson66309 ай бұрын
One of the all-time greats. 5 stars!
@venkatr49727 ай бұрын
You're my Savior.. Thanks much . please post more update format in Expression
@1yyymmmddd2 ай бұрын
Great tutorial. Can Power Automate handle complex queries? Does it support all DAX functions?
@RyanOlexa3 ай бұрын
This was sooooo helpful! Thanks so much!
@manassehkisame628618 күн бұрын
This was a life saver!
@JannievanderWalt11 ай бұрын
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. 🙏🙏🙏🙏🙏🙏
@HatFullOfData12311 ай бұрын
Glad it helped!
@gthornbu9 ай бұрын
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')
@sjwendell3 ай бұрын
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.
@HatFullOfData1233 ай бұрын
It had me confused for ages
@MarcusCrutchfield9 ай бұрын
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?
@HatFullOfData1238 ай бұрын
You can get rid of it as we don't refer to it. Good point!
@MrTC-rv3jo6 ай бұрын
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!
@wadanda10 ай бұрын
Excellent video!
@HatFullOfData12310 ай бұрын
Glad you liked it!
@mirrrvelll51646 ай бұрын
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?
@HatFullOfData1236 ай бұрын
If the semantic model is refreshed the data fetched should be refreshed. How are you specifying your date range in the DAX?
@mirrrvelll51646 ай бұрын
@@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?
@HatFullOfData1236 ай бұрын
Making the DAX dynamic is the best way.
@Bananaskin110 ай бұрын
Has the Dax feature been removed? I am running the Feb 2024 release and I'm only seeing the standard 3 options.
@Bananaskin110 ай бұрын
Forget my previous question, I hadn't realised that there was a preview features facility
@sujatarao991310 ай бұрын
Hi, I need to write table visual data from powerbi to sql server via power automate , how can I do that ?
@sofianeboukecha11 ай бұрын
great video, thank you can we do the same thing to extract an XLSX file, not HTML table?
@HatFullOfData12311 ай бұрын
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
@sofianeboukecha11 ай бұрын
After the Json step?
@bangerasiddharth2 ай бұрын
Helpful, thanks.
@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 Жыл бұрын
Capacity*
@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.