I have some question about Semantic Model. Can I use semantic model from lakehouse to create new paraemeter? In my semantic model I can't create New Column and New Table. How can I create them?
@AmitChandak18 сағат бұрын
This feature was enabled for only a week and was later disabled.
@DulceDelgado-q5mКүн бұрын
Thank your sir! I really appreciate your clear and straightforward explanation.
@AmitChandakКүн бұрын
Glad it was helpful!
@ANFALKARIM-t6tКүн бұрын
are these Hindi series enough to learn or need to go through English series also?
@AmitChandakКүн бұрын
It is a good starting point. But English series has more content.
@benkloosterman7934Күн бұрын
I found copy task really expensive CU wise. billing out a minute even if it takes a second or 2.,
@AmitChandakКүн бұрын
Can you share some more details or ping me on LinkedIn and share some screenshot- www.linkedin.com/in/amitchandak78/
@nokam1132 күн бұрын
Sir can you share link of other video which you are referring for advance level of power Bi at the start of the video ?
@AmitChandak2 күн бұрын
Please refer to this series Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html Also, refer how to break a file, in first few video of the series Mastering Power BI 230+ videos: kzfaq.info/get/bejne/rdyjdN2F1rmohps.html
@azizquazi3 күн бұрын
Hi Amit, these are the significant collections for the interview preparation. Can we get the PBIX file that you demonstrated? Thanks.
@AmitChandak2 күн бұрын
Please find the files Part 1- github.com/amitchandakpbi/powerbi/blob/main/Power%20Bi%20Interview%20Part%201.pbix Part 2- github.com/amitchandakpbi/powerbi/blob/main/AT%20Interview%20Questions%20Part%202%20Video.pbix Blog Links: Power BI Interview Part 1: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Power BI Interview Part 2: amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84 Series Link- Power BI Interview Questions - 60+ Videos: kzfaq.info/get/bejne/rNx2eqRyx8rXYZ8.html
@noeldeepakpalle4424 күн бұрын
I am using Databricks table. I have followed the steps to enable folding, but still not able to see 'view native query' enabled
@amitkumarkumarsinghpiyush3235 күн бұрын
Can you upload the questions along with answers please
@AmitChandak5 күн бұрын
I think you need these questions in a document format. You can find them on the Medium blog. Power BI Interview Part 1: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Power BI Interview Part 2: amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84
@yakaba6 күн бұрын
You just earned a thumbs up and a follow. Your solution worked for my case.
@AmitChandak5 күн бұрын
Thanks. I hope you will enjoy the full series as well. Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html
@rickpetty21976 күн бұрын
How do you specify precision on a datetime column in this table? I can see that these columns create a datetime2(6) data type, but the dates I’m needing to link to in my database are datetime2(0).
@ankittripathi83056 күн бұрын
Insightful one thanks.
@AmitChandak6 күн бұрын
Glad it was helpful!
@BryanWest-x2u6 күн бұрын
This is SUPER helpful! Thanks for putting this video together.
@AmitChandak6 күн бұрын
Glad it was helpful! Hope you will like the full series Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html
@outandaboutintheworl7 күн бұрын
thankyou so much, an excellent solution
@AmitChandak6 күн бұрын
You're welcome! Hope you will like the full series Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html
@sushantsharma30517 күн бұрын
Thanks a lot Amit Bhai!
@AmitChandak6 күн бұрын
Thanks. Hope you will like the full series Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html
@nishyt89129 күн бұрын
Isn’t hard for a fresher ?
@storieswithtarasharma29149 күн бұрын
This is not for freshers, this is good to get Job
@nishyt89129 күн бұрын
@@storieswithtarasharma2914 hello sir are you working as data Analyst?
@storieswithtarasharma29149 күн бұрын
@@nishyt8912 nahi
@jmmcco029 күн бұрын
This was very helpful, thanks!
@AmitChandak8 күн бұрын
Glad it was helpful!
@sonukumarskp693310 күн бұрын
Hindi me video hota to Jayda aucha hota ... Ab aap ye bolenge english mandatory wrna aapka interview clear nahi hoga to sir mai already data analyst hu company me but kya hai na better understanding to sirf apne mother language me hi hoti hai jo ki hindi hai ... Agar possible ho to Hindi me video banayea kyuki maximum students Hindi prefer karte hai sikhne me mamle me
@AmitChandak10 күн бұрын
Trying for more Hindi videos. You will see more content in coming days.
@sonukumarskp693310 күн бұрын
I joined this series
@AmitChandak10 күн бұрын
These are all videos Power BI Interview Questions series: kzfaq.info/get/bejne/rNx2eqRyx8rXYZ8.html
@sonukumarskp693311 күн бұрын
Sir Power BI Dax ka complete series leke aayea in hindi
@AmitChandak10 күн бұрын
Hope is series ke saare video dekh liye hain सीखे Power BI हिंदी में: kzfaq.info/sun/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki
@naveensharma943611 күн бұрын
Hi Amit, what is the difference between your free pBI course vs Paid pBI course, pls suggest
@AmitChandak11 күн бұрын
No big difference. The paid version has a few additional videos, and I am adding interview question videos directly to the course. In the free one, they are linked to KZfaq. If you got the free one, there's no need to buy the paid one.
@naveensharma943612 күн бұрын
Pls make a video on Composite Dual storage in hindi, it would be very helpful to us.
@shoeb135913 күн бұрын
Thanks for explaining Amit. Dax easy hota ja raha hai 😂. Request you to make one videos on handling large data in power bi using import mode. 4 lakh rows se upar hang hone lagta hai.
@AmitChandak12 күн бұрын
Okay sure
@shoeb135912 күн бұрын
@@AmitChandak i am facing one issue Hope you can advice me Distinct value getting increase when exporting data from Power BI visual to Excel. The same measure is showing correct value on power bi cards but using the same measures on clustered bar chart across schools its giving some extra 4 values when it’s getting exported in excel No of Student = var x = CALCULATE(DISTINCTCOUNT(Table[student ID])) return IF(ISBLANK(x),0,x)
@AmitChandak12 күн бұрын
In Excel you might be doing a sum. Power Bi do DISTINCTCOUNT again for Grand Total/Card, it is not sum of rows.
@biradarrajshri393313 күн бұрын
Sir i complete this video now I want start my first project in covid 19 so i have one question, without cleaning the covid data means without removing the null values in new death and new column can i start my build report? Sir please answer it🙏🏻☺
@AmitChandak13 күн бұрын
Yes, you can. Additionally, you can consider using a date table like we do in HR, joining with both dates and using USERELATIONSHIP for inactive joins. Power BI: HR Analytics - Employees as on Date : kzfaq.info/get/bejne/m5yJYM-Qr9qnoWg.html community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: kzfaq.info/get/bejne/nNyXlttptrLViok.html
@biradarrajshri393312 күн бұрын
Thank you so much sir 🙏🏻🙏🏻😊 wish to god give you lot of success🏆💪
@enkaibi275615 күн бұрын
Most all inclusive power bi video ever!
@amulyach509915 күн бұрын
If we are not having organisation mailid. How sir?
Is there a way to auto create a report in similar fashion based on multiple tables or semantic model using Notebooks?
@AmitChandak15 күн бұрын
Need to check. I will check and update.
@riteshkumar449316 күн бұрын
Great explanation, thanks. Just one thing if we use fabric so in that case Power BI Desktop tool is required or not?
@AmitChandak16 күн бұрын
Power BI Desktop tool is not required. But in Case you prefer to create report on Desktop, you can use that.
@riteshkumar449316 күн бұрын
@@AmitChandak Thanks. It means we can do all things in Microsoft Fabric, whatever we do in Power BI Desktop tool..
@sanjeebsen882717 күн бұрын
Yes
@AmitChandak15 күн бұрын
Hope you liked the video. Please check the series Mastering Microsoft Fabric in Hindi: kzfaq.info/get/bejne/bMeUqLKF1K_bpJs.html
@chuubry18 күн бұрын
stop this ai
@AmitChandak18 күн бұрын
Trying to check out the new AI tools-I've played around with a few in the past as well. Just an experiment with captions.ai
@chuubry18 күн бұрын
@@AmitChandak well ok but it's eerie
@AmitChandak18 күн бұрын
Yes, I agree. Looking at how good the video quality and word flow are, I'm afraid I would have had to do it a few times, and then finally editing would have made it possible. In Power BI, most of our videos require screen recordings with knowledge sharing, so we can still think there's some time before AI can do that. But if the content is only verbal and needs to be merged with videos and images, then AI can do that much faster. So, it is challenging.
@sanjibmanna51820 күн бұрын
Thank you for this help to merging excels in power BI
@DrewMiller-m9g21 күн бұрын
Really appreciate this video - helped me with sorting month!
@taniyaganguly21 күн бұрын
can you help to write query to see datatype of columns from table in fabric
@AmitChandak21 күн бұрын
In case of Lakehouse or Warehouse use SQL End Point and try this query SELECT top 100 * FROM INFORMATION_SCHEMA.COLUMNS
@taniyaganguly21 күн бұрын
@@AmitChandak it worked thank you
@Rajeeb70122 күн бұрын
Is it possible Simultaneously scrolling both matrix table in power bi?
@AmitChandak21 күн бұрын
I doubt that is possible
@ankittripathi830522 күн бұрын
hello Amit, I have made an ML model in fabric's notebook using test data, now I want to integrate the same ML model in Power BI and run the model for predictions, how can I achieve this? If possible can you make a video on this as I am not able to find any content related to this. Thanks, you can also comment the steps if it can be easily understood.
@manishagujralkhanna668822 күн бұрын
Hi Amit does fabric store a copy of this data and where this data exactly stores in fabric
@AmitChandak22 күн бұрын
Yes, It copies the data, unless we are using shortcuts. It stores data on Onelake(ADLS Gen2).
@sufiyantahir697823 күн бұрын
M not getting grand total in my power bi m using map visual any idea
@AmitChandak22 күн бұрын
@sufiyantahir6978, This video discusses the Matrix visual. I'm not able to connect it with what you need in the Map visual. Please provide more details.
@sufiyantahir697822 күн бұрын
@@AmitChandak Thanks for the response, Actually m looking grad total for all items like we use sum in Excel sheet
@sufiyantahir697822 күн бұрын
criteria what m selecting in visual if we see in report view in last row subtotals should reflect
@moeeljawad536126 күн бұрын
Hello Amit, that is wonderful thanks for sharing, at 18:42 you had mentioned that using the lookup activity is not the best practice if the table is very large, and you mentioned using a table approach, can you elaborate more on that? would having a script activity after the copy activity that will query the copied table, and get the maximum date stored in a table in the lakehouse, and then you directly lookup from that table be a possibility?
@magibis751926 күн бұрын
This video is super sir
@AmitChandak26 күн бұрын
Thanks a lot. Hope you will like full series. Power BI Concepts 180+ Videos: kzfaq.info/get/bejne/maehncSctdDGfYk.html
@parisajamsandekar143727 күн бұрын
In tableau, they are finding average for this fixed calculation. How to implement same in power bi?
@AmitChandak26 күн бұрын
@parisajamsandekar1437, For Avg above a level we use Averagex(Values(Item[Brand]), [Net]) to do so in Power bi with fixed LOD , you can use different columns in Averagex and allexcept calculate(Averagex(Values(Item[Brand]), [Net]) , allexcept(Sales, Item[Brand] ) ) also, please refer New Version: kzfaq.info/get/bejne/nrtdlrmA3Kqnpo0.html Avg of Sum : kzfaq.info/get/bejne/mbRodLJkxNzRnI0.html
@jithiljohn296129 күн бұрын
Hi Amit, Can we use year-month slicer instead of date between slicer, which is not working fine.
@AmitChandak26 күн бұрын
@jithiljohn2961 Even with month year, you need a disconnected table. When selecting a bigger range you need some kind of workaround, refer new version - kzfaq.info/get/bejne/bcqApbOcm7K0iYk.html
@AnthoniSagarikaPamisettyАй бұрын
But Sir we can only apply this technique if the data size is small.This is not possible if the data set has 20+M rows
@AmitChandak26 күн бұрын
In case of power bi, not good idea to do so on 20+ M rows. Better have that only in a dimension.
@austinnesbitt3822Ай бұрын
Thank you! This is just the solution I needed
@AmitChandakАй бұрын
You are welcome!
@shwetkumar1719Ай бұрын
Hello sir, Can we perform upsert in power query
@AmitChandakАй бұрын
I doubt that
@oyelajairemideАй бұрын
Thank you. This was very helpful
@AmitChandakАй бұрын
Glad it was helpful!
@bloggingbyasifali4984Ай бұрын
How many Power bi developers will be there in organisation? Startup, mid level and MNC?
@AmitChandakАй бұрын
There are more than 5 Million Power BI users worldwide. Also refer enlyft.com/tech/products/microsoft-power-bi www.readycontacts.com/target-account-profiling/microsoft-power-bi/
@velamurisarath562Ай бұрын
Super perfect match for my requirement
@monubhaiya9022Ай бұрын
Thank you so much for your help, sir. Your hard work is truly appreciated.
@AmitChandakАй бұрын
You are most welcome
@monubhaiya9022Ай бұрын
But you're a great teacher, sir. I'm really glad found you. Thank you for helping us.
@AmitChandakАй бұрын
You are very welcome
@ankittripathi8305Ай бұрын
hello, I have added data into lakehouse through Gen2 from sharepoint and then want to model the tables, however for two tables, I need many to many relationship, but there is no option for this, how can i achieve this in fabric? Also if I connect the model to Power Bi desktop and want to change the relationship to many to many it would be converted to import locale mode, however i want it in direct/live connection, your inputs please thanks
@AmitChandakАй бұрын
Please create a custom semantic model; you can have it there. But be careful, as many-to-many relationships sometimes do not work as expected. I have already shared this feedback with support team.
@ankittripathi8305Ай бұрын
@@AmitChandak thanks for reply actually we are migrating old semantic models to fabric, yes we will try to be careful with many to many relationship as do we in past. Thanks amit