2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
Пікірлер
@davidranwell9325 Ай бұрын
Yes Thank you so much for your valuable video really helpful David
@dataplatformcentral3036 Ай бұрын
Glad it was helpful! Feel free to share and subscribe :)
@CarlosSánchezFernández-f6l 2 ай бұрын
Thanks a lot!!! Helpful and on point!!
@dataplatformcentral3036 Ай бұрын
Glad it was helpful! Feel free to share and subscribe :)
@sarathkumardesappan4139 2 ай бұрын
Superb
@dataplatformcentral3036 Ай бұрын
Thanks 🤗
@virtualal7773 6 ай бұрын
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 5 ай бұрын
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 6 ай бұрын
How do we connect azure synapse pipeline runs status to power apps screen?
@dataplatformcentral3036 5 ай бұрын
Sorry can you elaborate on what you mean by run status? is it captured inside user table you created in Synapse?
@legendgod 6 ай бұрын
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 5 ай бұрын
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 7 ай бұрын
Can the Start Date and End date slicers showing as a calendar date picker instead of dropdown list?
@dataplatformcentral3036 Ай бұрын
yes If you bind it to a table containing the dates, it will come as a dropdown list
@hariharasudhan599 7 ай бұрын
awesome, you are genius.
@dataplatformcentral3036 5 ай бұрын
Thank you so much 😀 Feel free to like, share and subscribe
@JasonIz-kb7zf 7 ай бұрын
amazing! Thank you
@dataplatformcentral3036 5 ай бұрын
Glad you liked it! Feel free to like, share and subscribe
@leopuerto8039 7 ай бұрын
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 5 ай бұрын
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 7 ай бұрын
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 5 ай бұрын
Sorry that doesnt make sense Primary key doesnt have any direct relationship with credentials provided What credentials were you using? Account key?
@Roy_Entertainer 7 ай бұрын
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 7 ай бұрын
What kind of credential you're trying to pass? Account Key? or are you using synapse link?
@Roy_Entertainer 7 ай бұрын
@dataplatformcentral3036 it's the primary key provided inside the cosmos db...am new to this platform not sure about synapse link
@eddyjawed 7 ай бұрын
Nice video bro very helpful
@dataplatformcentral3036 7 ай бұрын
Glad it helped! Feel free to like, subscribe and share across :)
@ashishsah431 8 ай бұрын
Thanks a lot for the detailing.. video is super helpful.
@dataplatformcentral3036 8 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@mp_dev2000 9 ай бұрын
Awesome explanation!! You are a legend mate
@dataplatformcentral3036 8 ай бұрын
Glad you liked it! Feel free to like, share and subscribe :)
@SManok-r4t 9 ай бұрын
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 7 ай бұрын
Atleast some of these you can get by calling beta version of the below Graph API endpoint graph.microsoft.com/beta/me
@rishabhruwatia6201 9 ай бұрын
Hii, will it pull all the data of properties tab of user information??
@dataplatformcentral3036 7 ай бұрын
Whichever properties are exposed by the API would be returned.
@msuk-r4b 9 ай бұрын
Instead of drop down slicer, can’t we use the date picker?
@dataplatformcentral3036 8 ай бұрын
Nope. By default once a parameter is bound to table, the values will be populated into a dropdown
@karnatimanikantareddy9969 10 ай бұрын
Same way i want to update the data from sql to cosmos db under arry column can u do one video
@dataplatformcentral3036 8 ай бұрын
That would the same way. Just use the corresponding source and destination linked services.
@Phronesis1037 10 ай бұрын
Thank you! This looks fantastic especially for beginners like me :) I'm still at the early phases of my journey with Python.
@dataplatformcentral3036 10 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@joeysandoval7612 11 ай бұрын
@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 11 ай бұрын
Hi this feature is not coming in power bi now, any solution ?
@dataplatformcentral3036 10 ай бұрын
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 11 ай бұрын
Do you know if there is any performance limitation related to a big amount of data?
@dataplatformcentral3036 10 ай бұрын
You mean parsing large Parquet files in desktop? This is only limited by the main memory (RAM) of your desktop machine.
@sivasiva5611 11 ай бұрын
Hi Sir, Unable to see bind parameter . I am using store procedure and passing the parameter in my query ( Using import mode)
@dataplatformcentral3036 10 ай бұрын
Dynamic M query parameters is only available for Directquery sources not for Import mode.
@dalwingreen1986 11 ай бұрын
Thank you so much ! Excellent video.
@dataplatformcentral3036 10 ай бұрын
You are welcome! Glad you found it helpful Feel free to like, share and subscribe
@angiewang5796 11 ай бұрын
Hi, Do you know how I can get identities property of the user resource using ADF?
@dataplatformcentral3036 10 ай бұрын
Identities properties like?
@JaipalAnugandula 11 ай бұрын
Great video. One Question - Can we take date range slicer instead of selecting the particular date in StartDate and EndDate Slicers? Thanks!
@dataplatformcentral3036 10 ай бұрын
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 11 ай бұрын
Hello, I need to connect to a parquet file in Power Query, can you help with that?
@dataplatformcentral3036 11 ай бұрын
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 11 ай бұрын
This video is absolute gold dust and has saved me a huge amount of time. Thanks
@dataplatformcentral3036 11 ай бұрын
Glad it helped! Feel free to like, subscribe and share across
@JoEveritt Жыл бұрын
Dope video.
@dataplatformcentral3036 11 ай бұрын
Appreciate it!
@tranceinpeace Жыл бұрын
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 11 ай бұрын
By failed datasets do you mean failed data refreshes?
@ravinkabhi Жыл бұрын
you are a legend brother
@dataplatformcentral3036 11 ай бұрын
Thanks Feel free to like, share and subscribe :)
@alexochoki7533 Жыл бұрын
This video was really helpful. Thanks!
@dataplatformcentral3036 11 ай бұрын
Glad it was helpful! Feel free to like, share and subscribe :)
@sarveshsawant8089 Жыл бұрын
How can I implement the same for multiple containers?
@dataplatformcentral3036 11 ай бұрын
You can extend the same steps for the multiple containers you want. Just require corresponding linked services for each of them
@rohitbonde2010 Жыл бұрын
Thanks for this. Can we modify measures coming from model here in power bi ? if not , any alternative?
@dataplatformcentral3036 11 ай бұрын
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 Жыл бұрын
Nice video very helpful
@dataplatformcentral3036 Жыл бұрын
Glad it helped Feel free to like, subscribe and share across :)
@shubratkumar692 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
What is the error you're getting when you try this?
@wesleypereiradasilveira6049 2 ай бұрын
I had the same problem. In my case it was missing an "@" at the beginning, then I fixed it like this $['@odata.nextLink']
@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.