Тёмный
Data Platform Central
Data Platform Central
Data Platform Central
Подписаться
Platform to share educational videos on Power BI, Data platform related topics

Follow me on LinkedIn: www.linkedin.com/comm/mynetwork/discovery-see-all?usecase=PEOPLE_FOLLOWS&followMember=visakhsqlmvp
Комментарии
@virtualal7773
@virtualal7773 Месяц назад
Hi, I see your de-selected business phones. How do you include business phones as leaving it ticket when its set with the format its in seems to fail.
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
In my case there was no business phone value as it was a sample illustration. What was the error when you tried to include it? Thanks
@kathisreenivasulu6414
@kathisreenivasulu6414 Месяц назад
How do we connect azure synapse pipeline runs status to power apps screen?
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Sorry can you elaborate on what you mean by run status? is it captured inside user table you created in Synapse?
@legendgod
@legendgod Месяц назад
Maybe I missed it.. but why you need Synapse? Power App have dataverse connector so it can read/write in real-time I believe?
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Yes.. you missed the scenario The post is about how you can utilize Synapse link functionality in Dataverse to extract data close to real-time from PowerApps and use it for analytical processing in Synapse without any kind of additional ETL setup Thanks
@lzhao7573
@lzhao7573 Месяц назад
Can the Start Date and End date slicers showing as a calendar date picker instead of dropdown list?
@hariharasudhan599
@hariharasudhan599 2 месяца назад
awesome, you are genius.
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Thank you so much 😀 Feel free to like, share and subscribe
@JasonIz-kb7zf
@JasonIz-kb7zf 2 месяца назад
amazing! Thank you
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Glad you liked it! Feel free to like, share and subscribe
@leopuerto8039
@leopuerto8039 2 месяца назад
Can you do this at the report level? Imagine you have an app in a report. Will this work in the report or only with dashboards?
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Streaming datasets will work in Power BI reports as well. If you set the auto-refresh option, the report will automatically show the new data added to streaming dataset
@Roy_Entertainer
@Roy_Entertainer 2 месяца назад
While providing the primary key, power BI is giving the error " We couldn't authenticate with the credentials provided." although I am copying it correctly
@dataplatformcentral3036
@dataplatformcentral3036 19 дней назад
Sorry that doesnt make sense Primary key doesnt have any direct relationship with credentials provided What credentials were you using? Account key?
@Roy_Entertainer
@Roy_Entertainer 2 месяца назад
While connecting to cosmos db, there is a error in power bi saying "we couldn't authenticate with the credentials provided" tried to make changes in data source settings...still not working.
@dataplatformcentral3036
@dataplatformcentral3036 2 месяца назад
What kind of credential you're trying to pass? Account Key? or are you using synapse link?
@Roy_Entertainer
@Roy_Entertainer 2 месяца назад
@dataplatformcentral3036 it's the primary key provided inside the cosmos db...am new to this platform not sure about synapse link
@eddyjawed
@eddyjawed 2 месяца назад
Nice video bro very helpful
@dataplatformcentral3036
@dataplatformcentral3036 2 месяца назад
Glad it helped! Feel free to like, subscribe and share across :)
@ashishsah431
@ashishsah431 3 месяца назад
Thanks a lot for the detailing.. video is super helpful.
@dataplatformcentral3036
@dataplatformcentral3036 3 месяца назад
Glad it was helpful! Feel free to like, share and subscribe :)
@mp_dev2000
@mp_dev2000 4 месяца назад
Awesome explanation!! You are a legend mate
@dataplatformcentral3036
@dataplatformcentral3036 3 месяца назад
Glad you liked it! Feel free to like, share and subscribe :)
@user-zg1gu3bu8w
@user-zg1gu3bu8w 4 месяца назад
Hi Visakh, how to get these fields in Ms Entra ID using Graph API. Please share your thoughts. Thanks Job title Company name Department Employee ID Employee type Employee hire date Employee org data Office location Manager
@dataplatformcentral3036
@dataplatformcentral3036 2 месяца назад
Atleast some of these you can get by calling beta version of the below Graph API endpoint graph.microsoft.com/beta/me
@rishabhruwatia6201
@rishabhruwatia6201 4 месяца назад
Hii, will it pull all the data of properties tab of user information??
@dataplatformcentral3036
@dataplatformcentral3036 2 месяца назад
Whichever properties are exposed by the API would be returned.
@user-qe2tg2pg4c
@user-qe2tg2pg4c 4 месяца назад
Instead of drop down slicer, can’t we use the date picker?
@dataplatformcentral3036
@dataplatformcentral3036 3 месяца назад
Nope. By default once a parameter is bound to table, the values will be populated into a dropdown
@karnatimanikantareddy9969
@karnatimanikantareddy9969 4 месяца назад
Same way i want to update the data from sql to cosmos db under arry column can u do one video
@dataplatformcentral3036
@dataplatformcentral3036 3 месяца назад
That would the same way. Just use the corresponding source and destination linked services.
@Phronesis1037
@Phronesis1037 5 месяцев назад
Thank you! This looks fantastic especially for beginners like me :) I'm still at the early phases of my journey with Python.
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
Glad it was helpful! Feel free to like, share and subscribe :)
@joeysandoval7612
@joeysandoval7612 6 месяцев назад
@dataplatformcentral3036 I'm trying to set this up to pull from a different tenant subscription, but it can't find the application ID when I try to setup the linked sevice. Is this possible?
@yuvrajsingh9961
@yuvrajsingh9961 6 месяцев назад
Hi this feature is not coming in power bi now, any solution ?
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
This should be generally available now so you don't require enabling anything in the preview features, assuming that was what you were asking for.
@fla1910
@fla1910 6 месяцев назад
Do you know if there is any performance limitation related to a big amount of data?
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
You mean parsing large Parquet files in desktop? This is only limited by the main memory (RAM) of your desktop machine.
@sivasiva5611
@sivasiva5611 6 месяцев назад
Hi Sir, Unable to see bind parameter . I am using store procedure and passing the parameter in my query ( Using import mode)
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
Dynamic M query parameters is only available for Directquery sources not for Import mode.
@dalwingreen1986
@dalwingreen1986 6 месяцев назад
Thank you so much ! Excellent video.
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
You are welcome! Glad you found it helpful Feel free to like, share and subscribe
@angiewang5796
@angiewang5796 6 месяцев назад
Hi, Do you know how I can get identities property of the user resource using ADF?
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
Identities properties like?
@user-ol5bc6sc1o
@user-ol5bc6sc1o 6 месяцев назад
Great video. One Question - Can we take date range slicer instead of selecting the particular date in StartDate and EndDate Slicers? Thanks!
@dataplatformcentral3036
@dataplatformcentral3036 5 месяцев назад
Nope As of now, you need to have separate date filters for start and end dates and use the values in the M query for filtering
@aayushijajodia4681
@aayushijajodia4681 6 месяцев назад
Hello, I need to connect to a parquet file in Power Query, can you help with that?
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
That is already discussed in the video. Connecting to parquet file. If you open the query in PowerQuery editor you will be able to see the M code equivalent of this in the advanced editor.
@michaeldoyle4222
@michaeldoyle4222 6 месяцев назад
This video is absolute gold dust and has saved me a huge amount of time. Thanks
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
Glad it helped! Feel free to like, subscribe and share across
@JoEveritt
@JoEveritt 7 месяцев назад
Dope video.
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
Appreciate it!
@tranceinpeace
@tranceinpeace 7 месяцев назад
Great video found among all,, Can you send a sample query to get a failed datasets Is it possible? If possible please let us know. Thanks in advance
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
By failed datasets do you mean failed data refreshes?
@ravinkabhi
@ravinkabhi 7 месяцев назад
you are a legend brother
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
Thanks Feel free to like, share and subscribe :)
@alexochoki7533
@alexochoki7533 7 месяцев назад
This video was really helpful. Thanks!
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
Glad it was helpful! Feel free to like, share and subscribe :)
@sarveshsawant8089
@sarveshsawant8089 7 месяцев назад
How can I implement the same for multiple containers?
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
You can extend the same steps for the multiple containers you want. Just require corresponding linked services for each of them
@rohitbonde2010
@rohitbonde2010 7 месяцев назад
Thanks for this. Can we modify measures coming from model here in power bi ? if not , any alternative?
@dataplatformcentral3036
@dataplatformcentral3036 6 месяцев назад
Nope. You cant modify measures which are coming from an already deployed model. You can create another measure which extends it though like, for example, adding YTD based on existing measure etc
@ContainsAll
@ContainsAll 7 месяцев назад
Nice video very helpful
@dataplatformcentral3036
@dataplatformcentral3036 7 месяцев назад
Glad it helped Feel free to like, subscribe and share across :)
@shubratkumar692
@shubratkumar692 8 месяцев назад
I hav doubt sir In normal sql we mention bith tables , but i am not able yo get where is P table and how it is joined directly
@dataplatformcentral3036
@dataplatformcentral3036 7 месяцев назад
p is the alias for parents collection within JSON. CosmosDB is like document database and f.parents will point to parents JSON collection within each Families JSON. That is aliased as p and used to retrieve the values within it.
@pauf.9111
@pauf.9111 9 месяцев назад
Thank you very much !!
@dataplatformcentral3036
@dataplatformcentral3036 8 месяцев назад
You are welcome! Feel free to like, follow and subscribe :)
@lwhieldon1
@lwhieldon1 9 месяцев назад
Hi! I am not able to get pagination to work using the AbsoluteUrl: ${'@odata.nextLink'} functionality you described in your video. Do you have any updates on how to successfully pagination to return all AD users? Thanks!
@dataplatformcentral3036
@dataplatformcentral3036 8 месяцев назад
What is the error you're getting when you try this?
@r.osorio02CR
@r.osorio02CR 9 месяцев назад
Thanks! Do you hace a tip for queries across two or more documents?
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
You're welcome Can you elaborate what you want to retrieve from two or more document?
@arunkoshyg
@arunkoshyg 9 месяцев назад
Nice presentation. Its a dynamic report isn't it. I mean values changing on real time basis.
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
Yes Its dynamic based on slicer value selection
@MrSatishc84
@MrSatishc84 9 месяцев назад
Need to know how to use joins in Azure Synapse Cosmos DB
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
Its explained here learn.microsoft.com/en-us/azure/cosmos-db/nosql/query/join
@planetkc
@planetkc 9 месяцев назад
I don't have option to Create Formatted table in the ellipses
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
That is part of the paginated report feature which is a premium one. Are you on Premium capacity?
@13akanksha
@13akanksha 9 месяцев назад
I cannot find the option on bind to parameter, why so ??
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
Are you using a directquery based datasource?
@user-ye2jh9of1x
@user-ye2jh9of1x 9 месяцев назад
Thank you very much my friend!
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
You are very welcome Feel free to like, share and subscribe :)
@user-pi2rp7tk4u
@user-pi2rp7tk4u 10 месяцев назад
Does it work if the datasource is Oracle SQL?
@dataplatformcentral3036
@dataplatformcentral3036 9 месяцев назад
Havent tried it myself. Ideally it should support all directquery datasources and Oracle is specified as a directquery datasource
@GATE_Education
@GATE_Education 10 месяцев назад
recent version no live connection option Azure Analysis Services
@dataplatformcentral3036
@dataplatformcentral3036 10 месяцев назад
Nope . The option is still there
@tatsianastarastsenka6251
@tatsianastarastsenka6251 10 месяцев назад
Hi, Thank you for the video. It's great. Have you tried with multi-selection for parameters of date type? I really need this.
@dataplatformcentral3036
@dataplatformcentral3036 10 месяцев назад
Yes I have You just need to modify the query accordingly to parse list of values for multi-select
@hadialmumayez999
@hadialmumayez999 11 месяцев назад
does it work on power bi server?
@dataplatformcentral3036
@dataplatformcentral3036 10 месяцев назад
Are you asking about the On-Premise component Power BI Report Server?
@cosminmoga3037
@cosminmoga3037 11 месяцев назад
Great video sir!. What if I need a 4th parameter that is let's say an item form that store? How can I make the store slicer, filter the 4th parameter? Right now I am stuck at this for more than 2 months and I cannot find a way to do it. THX! Basicaly I need the 4th slicer to be filtered by the store name and only after that to send the query
@dataplatformcentral3036
@dataplatformcentral3036 10 месяцев назад
You will add 4th parameter also exactly like the others and generate the query dynamically based on it.
@arunv1909
@arunv1909 11 месяцев назад
I hope you post more videos , can you pls explain dax studio
@dataplatformcentral3036
@dataplatformcentral3036 10 месяцев назад
Thank. Surely will add more informative videos in future DAX studio has a good documentation already daxstudio.org/docs/intro/
@arunv1909
@arunv1909 10 месяцев назад
@@dataplatformcentral3036 thanks for sharing
@davidezam
@davidezam 11 месяцев назад
Thanks for the video .. Everything works . Just one question: must the Power Bi report be updated manually or is there a possibility that it will be updated automatically? Thanks in advance . Davide
@dataplatformcentral3036
@dataplatformcentral3036 11 месяцев назад
Nope. No need to update manually. Since its push dataset data gets automatically added. In Power BI you can set up page refresh option to auto-refresh data if you want.
@user-jg5mg8nf8s
@user-jg5mg8nf8s 11 месяцев назад
Thank you ,this is quite helpful.
@dataplatformcentral3036
@dataplatformcentral3036 11 месяцев назад
Glad it was helpful! Feel free to like, share and subscribe across :)