2 жыл бұрын
Пікірлер
@virtualal7773 4 ай бұрын
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 3 ай бұрын
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 4 ай бұрын
How do we connect azure synapse pipeline runs status to power apps screen?
@dataplatformcentral3036 3 ай бұрын
Sorry can you elaborate on what you mean by run status? is it captured inside user table you created in Synapse?
@legendgod 5 ай бұрын
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 3 ай бұрын
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 5 ай бұрын
Can the Start Date and End date slicers showing as a calendar date picker instead of dropdown list?
@hariharasudhan599 5 ай бұрын
awesome, you are genius.
@dataplatformcentral3036 3 ай бұрын
Thank you so much 😀 Feel free to like, share and subscribe
@JasonIz-kb7zf 5 ай бұрын
amazing! Thank you
@dataplatformcentral3036 3 ай бұрын
Glad you liked it! Feel free to like, share and subscribe
@leopuerto8039 5 ай бұрын
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 3 ай бұрын
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 5 ай бұрын
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 3 ай бұрын
Sorry that doesnt make sense Primary key doesnt have any direct relationship with credentials provided What credentials were you using? Account key?
@Roy_Entertainer 5 ай бұрын
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 5 ай бұрын
What kind of credential you're trying to pass? Account Key? or are you using synapse link?
@Roy_Entertainer 5 ай бұрын
@dataplatformcentral3036 it's the primary key provided inside the cosmos db...am new to this platform not sure about synapse link
@eddyjawed 6 ай бұрын
Nice video bro very helpful
@dataplatformcentral3036 6 ай бұрын
Glad it helped! Feel free to like, subscribe and share across :)
@ashishsah431 6 ай бұрын
Thanks a lot for the detailing.. video is super helpful.
@dataplatformcentral3036 6 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@mp_dev2000 7 ай бұрын
Awesome explanation!! You are a legend mate
@dataplatformcentral3036 6 ай бұрын
Glad you liked it! Feel free to like, share and subscribe :)
@SManok-r4t 7 ай бұрын
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 6 ай бұрын
Atleast some of these you can get by calling beta version of the below Graph API endpoint graph.microsoft.com/beta/me
@rishabhruwatia6201 7 ай бұрын
Hii, will it pull all the data of properties tab of user information??
@dataplatformcentral3036 6 ай бұрын
Whichever properties are exposed by the API would be returned.
@msuk-r4b 8 ай бұрын
Instead of drop down slicer, can’t we use the date picker?
@dataplatformcentral3036 6 ай бұрын
Nope. By default once a parameter is bound to table, the values will be populated into a dropdown
@karnatimanikantareddy9969 8 ай бұрын
Same way i want to update the data from sql to cosmos db under arry column can u do one video
@dataplatformcentral3036 6 ай бұрын
That would the same way. Just use the corresponding source and destination linked services.
@Phronesis1037 9 ай бұрын
Thank you! This looks fantastic especially for beginners like me :) I'm still at the early phases of my journey with Python.
@dataplatformcentral3036 8 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@joeysandoval7612 9 ай бұрын
@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 9 ай бұрын
Hi this feature is not coming in power bi now, any solution ?
@dataplatformcentral3036 8 ай бұрын
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 9 ай бұрын
Do you know if there is any performance limitation related to a big amount of data?
@dataplatformcentral3036 8 ай бұрын
You mean parsing large Parquet files in desktop? This is only limited by the main memory (RAM) of your desktop machine.
@sivasiva5611 9 ай бұрын
Hi Sir, Unable to see bind parameter . I am using store procedure and passing the parameter in my query ( Using import mode)
@dataplatformcentral3036 8 ай бұрын
Dynamic M query parameters is only available for Directquery sources not for Import mode.
@dalwingreen1986 9 ай бұрын
Thank you so much ! Excellent video.
@dataplatformcentral3036 8 ай бұрын
You are welcome! Glad you found it helpful Feel free to like, share and subscribe
@angiewang5796 9 ай бұрын
Hi, Do you know how I can get identities property of the user resource using ADF?
@dataplatformcentral3036 8 ай бұрын
Identities properties like?
@JaipalAnugandula 9 ай бұрын
Great video. One Question - Can we take date range slicer instead of selecting the particular date in StartDate and EndDate Slicers? Thanks!
@dataplatformcentral3036 8 ай бұрын
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 9 ай бұрын
Hello, I need to connect to a parquet file in Power Query, can you help with that?
@dataplatformcentral3036 9 ай бұрын
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 10 ай бұрын
This video is absolute gold dust and has saved me a huge amount of time. Thanks
@dataplatformcentral3036 9 ай бұрын
Glad it helped! Feel free to like, subscribe and share across
@JoEveritt 10 ай бұрын
Dope video.
@dataplatformcentral3036 9 ай бұрын
Appreciate it!
@tranceinpeace 10 ай бұрын
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 9 ай бұрын
By failed datasets do you mean failed data refreshes?
@ravinkabhi 10 ай бұрын
you are a legend brother
@dataplatformcentral3036 9 ай бұрын
Thanks Feel free to like, share and subscribe :)
@alexochoki7533 10 ай бұрын
This video was really helpful. Thanks!
@dataplatformcentral3036 9 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@sarveshsawant8089 10 ай бұрын
How can I implement the same for multiple containers?
@dataplatformcentral3036 9 ай бұрын
You can extend the same steps for the multiple containers you want. Just require corresponding linked services for each of them
@rohitbonde2010 10 ай бұрын
Thanks for this. Can we modify measures coming from model here in power bi ? if not , any alternative?
@dataplatformcentral3036 9 ай бұрын
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 11 ай бұрын
Nice video very helpful
@dataplatformcentral3036 11 ай бұрын
Glad it helped Feel free to like, subscribe and share across :)
@shubratkumar692 11 ай бұрын
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 10 ай бұрын
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 Жыл бұрын
Thank you very much !!
@dataplatformcentral3036 11 ай бұрын
You are welcome! Feel free to like, follow and subscribe :)
@lwhieldon1 Жыл бұрын
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 11 ай бұрын
What is the error you're getting when you try this?
@r.osorio02CR Жыл бұрын
Thanks! Do you hace a tip for queries across two or more documents?
@dataplatformcentral3036 Жыл бұрын
You're welcome Can you elaborate what you want to retrieve from two or more document?
@arunkoshyg Жыл бұрын
Nice presentation. Its a dynamic report isn't it. I mean values changing on real time basis.
@dataplatformcentral3036 Жыл бұрын
Yes Its dynamic based on slicer value selection
@MrSatishc84 Жыл бұрын
Need to know how to use joins in Azure Synapse Cosmos DB
@dataplatformcentral3036 Жыл бұрын
Its explained here learn.microsoft.com/en-us/azure/cosmos-db/nosql/query/join
@planetkc Жыл бұрын
I don't have option to Create Formatted table in the ellipses
@dataplatformcentral3036 Жыл бұрын
That is part of the paginated report feature which is a premium one. Are you on Premium capacity?
@13akanksha Жыл бұрын
I cannot find the option on bind to parameter, why so ??
@dataplatformcentral3036 Жыл бұрын
Are you using a directquery based datasource?
@BranislavSlavkovský Жыл бұрын
Thank you very much my friend!
@dataplatformcentral3036 Жыл бұрын
You are very welcome Feel free to like, share and subscribe :)
@SiddharthGupta-x7n Жыл бұрын
Does it work if the datasource is Oracle SQL?
@dataplatformcentral3036 Жыл бұрын
Havent tried it myself. Ideally it should support all directquery datasources and Oracle is specified as a directquery datasource
@GATE_Education Жыл бұрын
recent version no live connection option Azure Analysis Services
@dataplatformcentral3036 Жыл бұрын
Nope . The option is still there
@tatsianastarastsenka6251 Жыл бұрын
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 Жыл бұрын
Yes I have You just need to modify the query accordingly to parse list of values for multi-select
@hadialmumayez999 Жыл бұрын
does it work on power bi server?
@dataplatformcentral3036 Жыл бұрын
Are you asking about the On-Premise component Power BI Report Server?
@cosminmoga3037 Жыл бұрын
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 Жыл бұрын
You will add 4th parameter also exactly like the others and generate the query dynamically based on it.
@arunv1909 Жыл бұрын
I hope you post more videos , can you pls explain dax studio
@dataplatformcentral3036 Жыл бұрын
Thank. Surely will add more informative videos in future DAX studio has a good documentation already daxstudio.org/docs/intro/
@arunv1909 Жыл бұрын
@@dataplatformcentral3036 thanks for sharing
@davidezam Жыл бұрын
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 Жыл бұрын
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.
@Rehamosman-t2v Жыл бұрын
Thank you ,this is quite helpful.
@dataplatformcentral3036 Жыл бұрын
Glad it was helpful! Feel free to like, share and subscribe across :)