Hat Full Of Data

Пікірлер

@disalatilakaratne3280 8 күн бұрын

Is there a way to still make a gradient legend with the latest update?

@HatFullOfData123 8 күн бұрын

Haven't looked but I will tomorrow

@yogac3618 11 күн бұрын

can we add matrix to it?? like rows, columns and values like the matrix visual of pbi

@vrushabhwasulkar 28 күн бұрын

first satisfying video in a month... thank you

@HatFullOfData123 28 күн бұрын

Glad it helped

@urbatin9355 29 күн бұрын

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 29 күн бұрын

Thank you. It's what I try to do

@rafiullahkhan5543 Ай бұрын

Thats great at first minute i got my answers

@eduduazzolin Ай бұрын

I'm facing a lot of incorrect values when I add dimensions. :(

@HatFullOfData123 Ай бұрын

What combination of dimension and measures are you using?

@majidgolnar7415 Ай бұрын

Big thanks for such a great, informative videos.

@durhamdataco Ай бұрын

This is great, thanks for the demo

@ChristianPirlich Ай бұрын

With this approach, the columns are unfortunately given the logical name and not the display name. Is there a way to use the display name? Without renaming the columns manually

@jhofastcopas Ай бұрын

Is it possible to connect in real time? I am experiencing a delay in refreshing the information.

@HatFullOfData123 Ай бұрын

No it's not data source that you can connect as a direct query

@okke6691 Ай бұрын

Fantastic! Such a good explanation

@HatFullOfData123 Ай бұрын

Thanks ☺️

@matthewthomas7079 Ай бұрын

I found this video but to do this the workspace has to be backed by premium capactiy?

@norhashikinmohdyusoff506 Ай бұрын

Great.. thank you..

@stevehamann9624 Ай бұрын

Thank U this is the best Pipeline explaination for power bi vid

@abarairukia Ай бұрын

Just wanted to let you know that I have been struggling all day with trying to get this, I started with trying UNICHAR and realized it does not have a half star. As I was about to give up, your blog post and video showed up. I just want to say YOU ARE AMAZING!

@HatFullOfData123 Ай бұрын

So pleased it helped. This is why I do it

@abelgonzalez3640 Ай бұрын

Thank you so much for such a detailed explanation. Awesome!

@nitro5apenas825 Ай бұрын

I dont know why, but only me (who created the flow) can trigger it, if another person does, the flow does nothing.

@HatFullOfData123 Ай бұрын

Have you given them access to the flow? You need to share it

@gabrielemannoni4668 Ай бұрын

Bravissima!!!

@raymondchong6573 Ай бұрын

Thanks for this. How about Excel file ? I tried upload xlsx file and then try to load into table it doesnt allow me to. How to deal with Excel file source ? Please help, thanks

@walidhome4484 Ай бұрын

that great explanation

@eldaniz.bayramov 2 ай бұрын

This is such an excellent video, thank you very much!

@madhanrajmoorthy8843 2 ай бұрын

Hi, Great one Thank you. However, power BI is not allowing me to unpivot the data that comes from DataVerse table. If I unpivot, it immediately notifies to move to Import Mode. But I want it in DirQuery mode. Do you have any ideas to solve this issue?

@HatFullOfData123 2 ай бұрын

Direct query has restrictions. Behind the scenes it converts the query into SQL and there are limits on that. I'm no SQL expert but you could possibly write an SQL query that does the unpivot and then use this technique hatfullofdata.blog/using-sql-on-dataverse-for-power-bi/

@madhanrajmoorthy8843 2 ай бұрын

@@HatFullOfData123 🥰 Thanks a lot for your answer and link. Its great to know this. This could be a best solution for my goal to have live data using Dataverse instead ImportMode in Power BI..Let me try this.

@mirrrvelll5164 2 ай бұрын

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 2 ай бұрын

If the semantic model is refreshed the data fetched should be refreshed. How are you specifying your date range in the DAX?

@mirrrvelll5164 2 ай бұрын

@@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 2 ай бұрын

Making the DAX dynamic is the best way.

@enochbishop8298 2 ай бұрын

Hi FullHatOfData, Why did the reports show an increase in Test over Dev, and then another increase in Prod over Test regarding the # of Customers? Are records being duplicated? Not sure why the records are increasing per your example? Thank you

@HatFullOfData123 2 ай бұрын

There is more data in the test database than in the dev one. Same for prod.

@harshchovatiya-gh7hn 2 ай бұрын

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

@HatFullOfData123 2 ай бұрын

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

@harshchovatiya-gh7hn 2 ай бұрын

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

@TheKwattK 2 ай бұрын

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 2 ай бұрын

Already done. Take a look at this video and see if it helps kzfaq.info/get/bejne/eN95p5WZmtOYg2Q.htmlsi=7Dqs3qc01DliCd4I

@TheKwattK Ай бұрын

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

@MrTC-rv3jo 2 ай бұрын

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!

@sextquint 2 ай бұрын

I don't understand how it works. In which step did you program the bookmark to do a reset? Do you just name it "Reset" and it automatically does that?

@l.andreamolinalozano2196 2 ай бұрын

thank you! your video is amazing 😃

@pradiptahafid 3 ай бұрын

You may not have a lot of subscribers but you have saved the one who watched your videos. Really saves my time. Thank you very much!

@ivanarango4973 3 ай бұрын

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

@HatFullOfData123 3 ай бұрын

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

@venkatr4972 3 ай бұрын

You're my Savior.. Thanks much . please post more update format in Expression

@Alan-ps2ul 3 ай бұрын

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 KZfaq!

@HatFullOfData123 3 ай бұрын

Compose rescues me soooo many times

@Ploplox 3 ай бұрын

My company disables add ins for PowerPoint so sad i cant use this!

@HatFullOfData123 3 ай бұрын

I agree that is sad.

@sukumarmusalaboina4495 3 ай бұрын

Hi , Is it possible to use SQL Analytics Endpoint as a source in Azure data factory - Copy activity. If yes, can I run the data from query instead of a table or view.

@saharaharris 4 ай бұрын

Fantastic tutorial - thanks!

@raghumajji2326 4 ай бұрын

Hi Laura, I followed your steps PBI automate is working however i am not able open the .pdf or .xls file which we receive in the mail...Could you please help me on this ?

@junedshaikh2964 4 ай бұрын

How to get the PWA link from project online?

@danny1206ec 4 ай бұрын

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

@HatFullOfData123 4 ай бұрын

Glad it helped

@thaotuong7963 4 ай бұрын

This is clear and very helpful, thank you!

@HatFullOfData123 4 ай бұрын

You're very welcome!

@Bananakillaaa 4 ай бұрын

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

@HatFullOfData123 4 ай бұрын

Great to hear!

@bc67 4 ай бұрын

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 4 ай бұрын

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

@riazahmedshaik 4 ай бұрын

Hi , I'm getting the file to the email but when I tried to open the file, it is giving corrupted file error. How to over come this? Please help me here

@BadHoneyBadger 5 ай бұрын

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

@HatFullOfData123 5 ай бұрын

Glad you liked it. I revisited this topic to rename the columns and make it pretty kzfaq.info/get/bejne/eN95p5WZmtOYg2Q.html

@osPA78 5 ай бұрын

Very simple explanation on the steps for deployment. Thank you!!!

@HatFullOfData123 5 ай бұрын

Glad it was helpful!

@MarcusCrutchfield 5 ай бұрын

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 5 ай бұрын

You can get rid of it as we don't refer to it. Good point!

@NisarErkut-sd1oc 5 ай бұрын

Hi, I followed the steps but my table doesn't show up in the Table folder in my lakehouse. Even I pick the right lakehouse and container. Do you have any suggestions to solve this?

@HatFullOfData123 5 ай бұрын

Did the dataflow refresh okay?

@careyjohnson6630 5 ай бұрын

One of the all-time greats. 5 stars!

@careyjohnson6630 5 ай бұрын

You da best

Ең жақсы KZfaq

Пікірлер