2 жыл бұрын
3 жыл бұрын
3 жыл бұрын
3 жыл бұрын
Пікірлер
@cupicapbleew1460 9 күн бұрын
How to create new table on dataset? Becauss new table is disable
@insightsoutliers 8 күн бұрын
If you add a new table to the underlying Lakehouse, you should be able to add it to the custom Semantic Model afterwards.
@ralphsparkle 25 күн бұрын
The sections at 3:32 and beyond, seem to suggest that Co-Pilot can pull in data from external sources - is this correct?
@insightsoutliers 24 күн бұрын
Copilot connects to an Azure OpenAI model to generate additional context to enrich the report. The data is external to the Power BI Semantic Model, but nothing is being pulled from the public internet for the responses.
@user-gq8sh1tc4q Ай бұрын
How can edit the ARM template after deploy it. I have created linked integration runtime for the target data factory and I want to configure all my resources to utilize this integration runtime
@insightsoutliers Ай бұрын
Is this thread helpful? stackoverflow.com/questions/57505831/how-to-update-and-redeploy-arm-template
@Francesca-yu5cy 4 ай бұрын
omg you are genious - danke!
@sphscholz 4 ай бұрын
Liked this very much. Even though I have been involved with BI for a long time, I am relatively new to the MS tool stack and this is a really helpful overview, thnx!
@paulpurington8637 4 ай бұрын
What a great presentation! Excellent stroll down memory lane. I wrote a book with Dan English about PowerView back in the day and PowerView got scrapped within days of the book's release. LOL!
@insightsoutliers 4 ай бұрын
Thank you, it was fun to put it all together. It's unreal the velocity of change with product improvements and changes. The right side of my primary diagram would even be a little bit different today versus when I put it together a few months ago.
@majeedadil777 4 ай бұрын
Thanks for sharing. when the data is loaded into the delta parquet table then how we can do the partition on the Year column?
@insightsoutliers 4 ай бұрын
Adding a step using Data Pipelines should be a straightforward way to add partitions: learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition
@nalinkhosla587 4 ай бұрын
Thanks for the insights, how much of the Fabric promised land is real vs roadmap/vision?
@insightsoutliers 4 ай бұрын
It's all there but some parts are more mature than others. This roadmap should help with any questions on this topic: aka.ms/fabricroadmap
@sunnysaneeth6693 4 ай бұрын
Why did you use date.csv file in this ?
@insightsoutliers 4 ай бұрын
At the time it was a simple way to add a Date table to the Gold layer. It also shows that you can strategically unite data from different sources with a Lakehouse architecture. I'd probably do it differently today with Fabric.
@blendcloud 4 ай бұрын
great presentation and thank you for providing this visual roadmap. even though i've experienced all of these technologies first hand since sql 7, it's actually a good reminder of how the individual components have evolved and now converged into fabric.
@tripathifamily2465 5 ай бұрын
nice one
@sanjay98317 5 ай бұрын
Superb! Thanks so much for connecting all the dots, and making the Fabric strategy and roadmap so clear.
@kdcapparelli 5 ай бұрын
Great presentation. Congratulations. I've always liked to "sense" the evolution of IT offerings (software products and services)
@angelost1467 5 ай бұрын
Very nice summary, thank you for taking the time to share it!
@ankeet1 5 ай бұрын
Things just went berserk around 2022, in a good way! I can totally relate to everything from SQL 7 until it had just started going Azure and then the advancement is exponential each year! Very informative reference video, Greg. Thank you!
@shantanumathur1059 5 ай бұрын
Very insightful article
5 ай бұрын
Great job! Thank you!
@adin6429 5 ай бұрын
I know only excel, power pivot, power query, power bi and very little sql. What should I learn to understand and work in fabirc?
@insightsoutliers 5 ай бұрын
The Fabric Career Hub would be a great place to start: aka.ms/fabriccareerhub
@adin6429 5 ай бұрын
Thanks
@Andrewskji 5 ай бұрын
Crazy to think about how fast this has happened
@daustonian9331 5 ай бұрын
Oh how I wanted the decomp tree to have colors... but alas MS locked the code and even the old Proclarity people were not permitted to implement it for us! I may still have a performance point book or two around. It was a tough use case for sure. Thanks for walking us older folks along the trail.
@insightsoutliers 5 ай бұрын
Agreed! I think the newer Decomp Tree in PBI can change colors based on KPIs, but I agree that the old PerformancePoint version was a step down form ProClarity.
@rifkiamil 5 ай бұрын
Great job on compiling everything. I'd like to offer a small suggestion if that's all right. Engine - VertiPaq 1. a box for VertiPaq which connected with 1.1 PowerPivot 2010 Add-In for Excel 2010 1.2 Analysis Services Tabular Mode 1.3 SQL Server 2012 - Columnstore storage VertiPaq rename to xVelocity in 2012 Acquired 2. Maximal Innovative Intelligence which is connected 2.1 Microsoft Data Analyzer (2002) (for OLAP)
@insightsoutliers 5 ай бұрын
Excellent info that I didn't find anywhere on the web. Thank you! At some point I plan to update the presentation and I'll include this content.
@OMAKEM 5 ай бұрын
Great presentation, thanks
@barrysinni7556 5 ай бұрын
great presentation that cuts through all of the marketing nonsense and shows real lineage
@alexanderjacobs817 5 ай бұрын
Great content here. Filled in a lot of gaps that I have thought about from the last few years.
@aamoody81 5 ай бұрын
Good stuff. Thank you.
@bcrivatutub 5 ай бұрын
Loved your presentation, thank you for creating and sharing it! It may be worth mentioning that PowerPivot (the vertipaq engine) did not come from the blue (or green), but really from Analysis Services. It shipped initially only in Excel, but it was 100% analysis services.
@insightsoutliers 5 ай бұрын
Thank you! I've added a note to the description and the related LinkedIn post.
@CaribouDataScience 5 ай бұрын
Well, the problem you have to have a business email account which I don't.
@insightsoutliers 5 ай бұрын
I agree it would be nice to see a "Fabric per User" license in the future for small business owners and personal use.
@tanveerakhtar7213 6 ай бұрын
Excellent and precise presentation Well done
@MrSith-yp3yq 6 ай бұрын
Should you blur out the name in the bottom right visual?
@insightsoutliers 6 ай бұрын
Thank you for the suggestion, I'll see if I can edit the video. I tried to blur out names to be respectful of anyone who showed up on the screen by random chance, but the data is 100% public so there are no PII concerns. Anyone can download and/or search all of the data from this link: data.cms.gov/provider-summary-by-type-of-service/medicare-part-d-prescribers/medicare-part-d-prescribers-by-provider-and-drug
@MrSith-yp3yq 6 ай бұрын
Thanks for the information 🙂@@insightsoutliers
@khalidjaradat 6 ай бұрын
Thank you very much 🤩
@angelost1467 6 ай бұрын
In a world where everyone is pushing flashy over the top videos to grab attention, this video is a refreshing. Thank you for taking the time to produce something that adds so much value in a 5 minute video.
@NewsSports-ey1ke 6 ай бұрын
nice video
@ThePilli41 6 ай бұрын
Amazing work! I cant wait to see more of your content.
@gulhermepereira249 6 ай бұрын
hi, Greg. What Fabric Capacity did you use for this example? It ran really smoothly
@insightsoutliers 6 ай бұрын
It's the Free Trial, which I think is an F64.
@gulhermepereira249 6 ай бұрын
@@insightsoutliers awesome! The same as Power BI P1
@insightsoutliers 6 ай бұрын
yes the same as P1
@rakshadilip2277 6 ай бұрын
Hi, I have hit into a situation where my PowerBI dataset is taking 2hrs to refresh , which includes Data extraction using REST API from Jira(Attlasian) cloud and transformations to cater business requirement. Is there any alternatives , where I can extract the Jira data in PowerBI and push these data to one lake. Create tranformation in one lake and build analytics in PowerBI by connecting to one lake? Or any other suggestions ?
@insightsoutliers 6 ай бұрын
You can try connecting to the Jira API using Pipelines in Fabric, and then landing the data in OneLake. If the Jira connection doesn't yet work in Fabric (I have no way to test it), you can use Pipelines in Azure Data Factory to land the data in ADLSv2 and then shortcut it over to Fabric: learn.microsoft.com/en-us/azure/data-factory/connector-jira?tabs=data-factory .
@ashutoshnehete2397 6 ай бұрын
Thanks for posting, well explained!
@sahilkothekar9927 7 ай бұрын
Great Demo One question ,does the query made to open Ai had the context of complete data model or the visual on canvas along with the data in it
@insightsoutliers 7 ай бұрын
For the Narrative visual, at the time of this reply, it is for data on canvas. This is why it can work with very large data models. There is another natural language visual called Q&A that will query the whole data model, but that one doesn't allow for LLM prompts.
@terryliu3635 6 ай бұрын
Thanks for sharing! Quick question…does the refresh have to be manual?
@insightsoutliers 6 ай бұрын
@@terryliu3635 no, the refresh could be scheduled with Fabric Pipelines. The instructions use manual refresh since it is a one-time load.
@valentinloghin4004 8 ай бұрын
Amazing job !! Congrats !
@mrgodai01 8 ай бұрын
How come the manage roles security is grey out in my sematic model? could it be because my lakehouse is using shorcuts to a Gen2 storage?
@insightsoutliers 8 ай бұрын
Right now this is only available using the XMLA endpoint. I was told the GUI version will be available soon.
@user-bo7hr3nw6u 8 ай бұрын
What are the other activities we can achieve through azure devops for fabric? Other than fabric git integration
@insightsoutliers 8 ай бұрын
Here's a great article on that topic I'm reading from Reza Rad: radacad.com/version-control-in-power-bi-and-fabric
@muhammadrahman3510 9 ай бұрын
Very well explained demo. Please keep it up on next videos regarding Fabric. Thanks so much 😊
@trading_with_fish 9 ай бұрын
This is very interesting......does a solution like this work well in a data centric architecture like a UNS?
@insightsoutliers 9 ай бұрын
Fabric does have IoT components, but they are not part of this video.
@maggietheutubedog 9 ай бұрын
Great job. No music. No BS. Just a huge amount of knowledge transferred in 5 minutes.
@utilars 10 ай бұрын
Is there a way to activate version control for all uploaded files? What happens in the lakehouse if someone accidentally replaces MUP_DPR_RY21_P04_V10_DY19_NPIBN_1.csv with a blank file?
@insightsoutliers 10 ай бұрын
Fabric will have Git integration, and we should know more about version control options when it goes GA: blog.fabric.microsoft.com/en-us/blog/introducing-git-integration-in-microsoft-fabric-for-seamless-source-control-management
@saurabhshrigadi Жыл бұрын
I come across your video, loved it. What tips you give to person who is beginner in power bi?
@insightsoutliers Жыл бұрын
Thank you. For beginners, I would recommend starting with the free online learning: learn.microsoft.com/en-us/training/powerplatform/power-bi?WT.mc_id=powerbi_landingpage-marketing-page
@azurelearner4055 Жыл бұрын
Thanks for the video !!
@fgbasket Жыл бұрын
Great video, very useful!
@charlesutton Жыл бұрын
I found this very useful. Thanks.
@JFCOFFEY87 Жыл бұрын
Just need access to the Open AI Private Preview now. :)
@alexandredemenezescastro Жыл бұрын
41:57 You placed the output file name in wrong Data flow, it must to be in BronzetoSilverGeo
@insightsoutliers Жыл бұрын
Thank you! I'll take a look and see if I can fix it.