Пікірлер
@arifurrahman27
@arifurrahman27 7 сағат бұрын
My MongoDB contains nested object. Once I connect to PowerBI, PowerBI shows only data with one level. objects with multiple levels show null. How to get nested object from mongo to PowerBI?
@rohinisondole3872
@rohinisondole3872 Күн бұрын
Hey, I completed the challenge on 21st june and 22nd june was the last day of the challenge. I received course completed but didn’t receive redeem code mail. Do you know how much time it takes to receive the redeem code mail?
@BIConsultingPro
@BIConsultingPro 22 сағат бұрын
Hi 👋 thanks for your reply. Unfortunately, this time they didn’t give vouchers but please stay tuned for the next time.
@darxcyber
@darxcyber Күн бұрын
really appreciate your video on this, i am just starting to use Power BI with no experience and you have just cut down my admin time greatly! many many thanks!
@BIConsultingPro
@BIConsultingPro 23 сағат бұрын
Really happy to hear it 🙏 thanks for your feedback
@vriyer1
@vriyer1 Күн бұрын
Thank you very helpful.root method didn't work. Only this worked.
@BIConsultingPro
@BIConsultingPro 23 сағат бұрын
Glad to hear that!!
@manohara3060
@manohara3060 2 күн бұрын
Sir. I got BI certificate on 2023 . It is only one valid. But I forgot to renew the certification. Is it free please advise
@BIConsultingPro
@BIConsultingPro Күн бұрын
Thank you for your question. Unfortunately, you need to appear again for the exam and you need to pay again. Only exam renew is free!! If it’s get expired, you need to again schedule the exam and pay the fee.
@kisho2679
@kisho2679 2 күн бұрын
how can they be published for online collaboration and publishing?
@BIConsultingPro
@BIConsultingPro Күн бұрын
Could you please explain a bit more? Are you talking about reports or dashboards? If that’s the case, you need to publish on web like Power Bi Service or tableau server and then share with others.
@prateekbhatt6204
@prateekbhatt6204 2 күн бұрын
Mind Blowing, Nice to see you are always motivative. Keep it up
@BIConsultingPro
@BIConsultingPro Күн бұрын
Thank you so much my friend for your valuable feedback
@nikhilshetty1212
@nikhilshetty1212 3 күн бұрын
Thanks for this video super helpful. I had to login through org account for it to work
@BIConsultingPro
@BIConsultingPro 23 сағат бұрын
Glad it helped! Thanks for your feedback
@conniecai-vn9ch
@conniecai-vn9ch 3 күн бұрын
I'm a pro user. but there is no manage alerts option for card or KPI in power bi service. i dont know why
@BIConsultingPro
@BIConsultingPro 23 сағат бұрын
It’s only available on Power BI Dashboard, not report. Did you check there?
@TomGee-n1n
@TomGee-n1n 5 күн бұрын
Help!? I have a slicer just like this that returns the selected value when used alone. But I don't understand why selectedvalue returns a single value if I use it in a measure like value = selectedvalue(slicertable[column]), but i can't use it in a measure like calculate([measure], column=selectedvalue(slicertable[column]). Can anyone explain why selected value is returning more than one value and how to prevent that?
@BIConsultingPro
@BIConsultingPro 9 сағат бұрын
Try this… SelectedProductCategories = VAR SelectedValues = VALUES(Sales[ProductCategory]) -- Get all selected values from the ProductCategory column RETURN CONCATENATEX( SelectedValues, Sales[ProductCategory], ", " )
@tonyl3762
@tonyl3762 5 күн бұрын
What if the slicer is a DATE RANGE? How do you do that??
@salwakhalyl7737
@salwakhalyl7737 6 күн бұрын
Thank you very much, please where can i find the username and password in the section of authentication?
@BIConsultingPro
@BIConsultingPro 5 күн бұрын
Have you already installed the gateway? If yes, then please make sure to start the machine where it’s installed and restart the gateway if required. Now, go to Power BI Service and go to the gateway management tab (Click on top hand right side, where admin portal options appears). There you can add a new connection and you’ll get the option.
@ZuzikFr
@ZuzikFr 6 күн бұрын
you really helped me, thanks a lot. i already was disappointed...
@BIConsultingPro
@BIConsultingPro 5 күн бұрын
I am glad it helped
@kuto1
@kuto1 7 күн бұрын
Does this work with Databricks (using Direct Query) as well?
@BIConsultingPro
@BIConsultingPro 7 күн бұрын
Yes, this should work there as well.
@AwesomeEndings
@AwesomeEndings 7 күн бұрын
Is it same way for Monthly forcast
@BIConsultingPro
@BIConsultingPro 5 күн бұрын
Yes but using DAX logic rather than using Power BI Desktop app
@frankopokukoduah194
@frankopokukoduah194 8 күн бұрын
if you are deploying a new report, will you use the existing pipeline or you can create a new pipeline. I created a new separate pipeline but I was not able to access any workspace to it because the old pipepline was assigned to the existing workspace. hence I had to use the existing pipeline and I had to re-published already existing report and the new report together to the app
@BIConsultingPro
@BIConsultingPro 7 күн бұрын
Thanks for your comment. Please note that we don't create new pipelines for each report; instead, we use one pipeline for an entire domain or department. When setting up a deployment pipeline, you must assign workspaces to it, otherwise it won't function properly. Before using any deployment pipeline, ensure that your reports are already published in the associated workspace. You can then move reports between workspaces using the deployment pipeline. Ideally, you should set up Dev, Test, and Production workspaces. Initially, publish your report to the Dev workspace. Once it's ready, use the deployment pipeline to move it from Dev to Test/Acceptance, and then to the Production workspace. Currently, you can create up to 10 stages in a deployment pipeline, depending on your needs.
@paulgallagher2987
@paulgallagher2987 8 күн бұрын
This is very helpful thankyou. Our Datasets are fed by Dataflows. If we use the same principle but using the Refresh Dataflow API, how can we then have the Refresh Dataset activity triggered only once the DF refresh is complete?
@BIConsultingPro
@BIConsultingPro 8 күн бұрын
Yes, you can use dataflows in a ADF pipelines
@BIConsultingPro
@BIConsultingPro 7 күн бұрын
Thank you for your question! I'm glad you found the video helpful. To trigger a dataset refresh only after the Dataflow refresh is complete, follow these steps: Trigger Dataflow Refresh: Use the Refresh Dataflow API in an Azure Data Factory (ADF) Web activity: POST api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/refreshes 2. Monitor Refresh Status: Poll the Dataflow refresh status using another Web activity: GET api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/refreshes 3. Conditional Execution: Use the status check output to trigger the dataset refresh once the Dataflow is complete. Trigger Dataset Refresh: Use a Web activity to refresh the dataset: POST api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes you can use Dataflow as an activity in your ADF pipeline.
@paulgallagher2987
@paulgallagher2987 7 күн бұрын
@@BIConsultingPro Wow!! Thank you so much for such a quick and detailed response. I really appreciate your help! Lets hope the execs appreciate getting their reports earlier in the morning too! :D
@user-ky9rv2kl6j
@user-ky9rv2kl6j 9 күн бұрын
Great to have Raza..
@____akshay____4339
@____akshay____4339 10 күн бұрын
Bro voice is not clear take pause show proper demo
@ajaysharma2061
@ajaysharma2061 10 күн бұрын
Thanks for your feedback. However, voice is perfectly fine and demo is good too. Could you please explain what exactly you are not able to follow up.
@osmonddsouzaRedeemer
@osmonddsouzaRedeemer 11 күн бұрын
how to migrate opentext magellan to Power BI?
@BIConsultingPro
@BIConsultingPro 10 күн бұрын
Steps will be the same as you can watch in this playlist
@KeerthiAbe
@KeerthiAbe 12 күн бұрын
Thank you for great content Sir!
@BIConsultingPro
@BIConsultingPro 11 күн бұрын
My pleasure!
@user-bw9xp7xi6u
@user-bw9xp7xi6u 14 күн бұрын
great video! thanks! =)
@BIConsultingPro
@BIConsultingPro 12 күн бұрын
Glad you liked it!
@knowledgegetter
@knowledgegetter 14 күн бұрын
Im a fresher new to power bi. can i do this certification
@BIConsultingPro
@BIConsultingPro 12 күн бұрын
Technically yes but for freshers, it’s not required
@Andrewsegas
@Andrewsegas 14 күн бұрын
Amazing, I tried for hours with chatgpt and you solved it so easy
@sourabhrajora7225
@sourabhrajora7225 15 күн бұрын
Fake accent first learn to pronounce properly
@VenkatesanVenkat-fd4hg
@VenkatesanVenkat-fd4hg 16 күн бұрын
I think, microsoft fabric includes powerBI also Am I correct?
@user-dy8xu7uj8k
@user-dy8xu7uj8k 16 күн бұрын
Hi BI Consulting Pro, I have some complex "Scalar user defined functions" defined in MYSQL and I have to migrate them to fabric, but as of now fabric doesn't support creation of "Scalar user defined functions" in warehouse. In this scenario please let me know alternative options I can use. Thanks
@yuvrajsingh9961
@yuvrajsingh9961 16 күн бұрын
The Data Source Rule is not getting enabled for me
@user-bm7uc6ml1s
@user-bm7uc6ml1s 16 күн бұрын
How to practice dax function
@BIConsultingPro
@BIConsultingPro 11 күн бұрын
www.dax.do
@digvijaysinghal3183
@digvijaysinghal3183 17 күн бұрын
Well Explained...Really Loved it...Sir i am from Nepal and Nepal Date is quite different from universal date pattern. Our First Month Name starts in Baisakh and End in Chaitra and Our fiscal year Starts in Shrawan and Ends in Ashad which means our first month lies on April 13-15 and and Fiscal Year lies on 15-17 July.....So, how can i match my custom dates with Universal Date. Please suggest........
@user-lj9fk8dg9h
@user-lj9fk8dg9h 17 күн бұрын
Sir, Can we extract the data from the warehouse to the Notebook, then transform it, then finally save it to the same warehouse ??
@user-lm5wb8vi1x
@user-lm5wb8vi1x 17 күн бұрын
Finished watching
@kommabalaji4845
@kommabalaji4845 17 күн бұрын
Sir kindly make a dedicated video on SQL profiler wrt to Power BI
@sirachayakk7261
@sirachayakk7261 17 күн бұрын
following the steps as explained, but resulting in the name of sheet/table firstly clicked, not the hidden table i desired. However, the content is from the hidden table/sheet ( i know from observing different columns)... Am i doing things correctly ? If yes, why power BI is so confusing?
@aslanjRuns
@aslanjRuns 17 күн бұрын
Is the same possible with the Import storage mode rather than the Direct Query?
@gagansingh3481
@gagansingh3481 18 күн бұрын
In upcoming feature AI skill kind of feature is coming out in which you select the table and ask your query it will write a write a sql query too ..
@gagansingh3481
@gagansingh3481 18 күн бұрын
Yes direct lake mode is really has useful feature of import and direct query mode in Microsoft fabric as compared to power bi desktop ...
@mohamedfiilow68
@mohamedfiilow68 18 күн бұрын
bro I have been facing an issue with preparing for the exam for Pl300 I bought the course but still have a problem Can you help me.
@BIConsultingPro
@BIConsultingPro 18 күн бұрын
Which course have you taken? Could you please explain in more detail and also the issue?
@mrbartuss1
@mrbartuss1 18 күн бұрын
Can we expect the timestamps?
@BIConsultingPro
@BIConsultingPro 18 күн бұрын
I am not sure if we can do it as it's live streamed but we'll try if it's possible.
@bensdidgroup3357
@bensdidgroup3357 18 күн бұрын
Thanks a lot. very useful
@BIConsultingPro
@BIConsultingPro 18 күн бұрын
You are welcome
@cedrickmbuyi3772
@cedrickmbuyi3772 19 күн бұрын
Not really helpful due to a lack of genuineness
@BIConsultingPro
@BIConsultingPro 18 күн бұрын
Thank you for your feedback. We appreciate it. We'll try to provide more information with Demos.
@BhargavChebolu
@BhargavChebolu 19 күн бұрын
Hi, if we change data in that excel, will it update in the Power BI?
@BIConsultingPro
@BIConsultingPro 18 күн бұрын
Yes! Please make sure you enter the credentials under dataset settings
@shaimainformativeandfunvid5039
@shaimainformativeandfunvid5039 19 күн бұрын
How to get free book?
@AtiqurRahman-uk6vj
@AtiqurRahman-uk6vj 20 күн бұрын
thanks . big help
@harshavardhan7124
@harshavardhan7124 20 күн бұрын
Thanks for the tutorial, I really appreciate it.
@youssefzaki9142
@youssefzaki9142 20 күн бұрын
Excellent video as always. Thanks so much
@Jukeshiaskjacob
@Jukeshiaskjacob 20 күн бұрын
What if I want to refresh all the semantic models in my workspace?
@BeeKianOng
@BeeKianOng 20 күн бұрын
saved my life. Thanks!