![Data Leaps](/img/default-banner.jpg)
- Видео 51
- Просмотров 44 083
Data Leaps
Великобритания
Добавлен 13 авг 2020
Welcome to Data Leaps, this is a data channel for Power BI, Databricks, DevOps, Platform Security, Career in Data, and Learning Resources.
I am Liping, Data & AI Solution Architect, ex-Microsoft, I specialize in Big Data Analytics, Data Engineering, Data Warehousing and Business Intelligence. In addition to creating content on RUclips, I am also a blogger (www.dataleaps.co.uk) and international public speaker (www.sessionize.com/lipinght), you can follow me on Linkedin (www.linkedin.com/in/lipinght) for content release notification.
The statements and views expressed here are mine alone.
I am Liping, Data & AI Solution Architect, ex-Microsoft, I specialize in Big Data Analytics, Data Engineering, Data Warehousing and Business Intelligence. In addition to creating content on RUclips, I am also a blogger (www.dataleaps.co.uk) and international public speaker (www.sessionize.com/lipinght), you can follow me on Linkedin (www.linkedin.com/in/lipinght) for content release notification.
The statements and views expressed here are mine alone.
#Data & #AI decoded: Live Webinar Announcement What is data & AI, How to #pivot into #career in Data
Registration Link: webinar.zoho.eu/meeting/register?sessionId=1239752804
❤️8 years ago I pivoted into Data & AI from a non-STEM background.
🙏Over the years, I coached many graduates/early-in-careers getting into technical Data & AI roles from various backgrounds.
⭐Today, an increasing number of people are asking me to help them advise/coach themselves or their loved ones to break into Data. 1:1 is no longer viable.
🚀So I am super excited to put together this Data & AI decoded webinar with Danny Razzaq to try and help more people in a scalable way.
Join us this Saturday 🚨20th July 2pm BST🚨, you will learn:
💡What is Data?
💡What is AI?
💡What do people who work in Data & AI do?
💡What roles/jobs exi...
❤️8 years ago I pivoted into Data & AI from a non-STEM background.
🙏Over the years, I coached many graduates/early-in-careers getting into technical Data & AI roles from various backgrounds.
⭐Today, an increasing number of people are asking me to help them advise/coach themselves or their loved ones to break into Data. 1:1 is no longer viable.
🚀So I am super excited to put together this Data & AI decoded webinar with Danny Razzaq to try and help more people in a scalable way.
Join us this Saturday 🚨20th July 2pm BST🚨, you will learn:
💡What is Data?
💡What is AI?
💡What do people who work in Data & AI do?
💡What roles/jobs exi...
Просмотров: 74
Видео
How to connect #PowerBI to #Databricks on AWS using SSO passthrough and use Unity Catalog ACL in PBI
Просмотров 123День назад
If you want to self-enrol for this feature docs.databricks.com/en/integrations/configure-aad-sso-powerbi.html If you want to download the notebook and the power bi template shown in this demo github.com/baatch/awsdb-pbi-sso In this video I invited my coworker Alex Phu (www.linkedin.com/in/alexander-phu-85866041/) to come and explain how Power BI on AWS Databricks SSO passthrough works. This is ...
How to #interview at #microsoft as Cloud Solution Architect or Technical Specialist #jobhunting
Просмотров 7314 дней назад
In this video, I go through the tips for interviewing as cloud solution architect and technical specialist at Microsoft. Chapters: 00:43 The screening round 03:25 The hiring manager and cross-functional round 05:03 The technical assessment round 09:34 The technical presentation round 12:12 The conclusion This video is part of the series "The Diary of a Solution Architect" ruclips.net/p/PLE_IpfS...
#Databricks Essentials: How to import CSV files in Databricks
Просмотров 7821 день назад
This video is part of the series "Databricks Essentials". In this series, I will cover the fundamentals of #Databricks, #deltalake, #apachespark, #mlflow, and #unitycatalog Hi, I am Liping, Data & AI Solution Architect, ex-Microsoft, I specialize in Big Data Analytics, Data Engineering, Data Warehousing and Business Intelligence. In addition to creating content on RUclips, I am also a blogger (...
What different types of architects do and their names in #databricks, #microsoft, #aws, #google
Просмотров 137Месяц назад
In this video, I covered what different types of architects do and how they are called differently in #databricks #microsoft #aws #google The roles covered in this video include: Solution Architects, Cloud Solution Architects, Partner Solution Architects, Partner Engineers, Customer Engineers, Sales Engineers, Specialist Solution Architects, Delivery Solution Architects, Customer Delivery Archi...
How to become a digital nomad as a data professional feat. Mara from datapears #data #digitalnomad
Просмотров 286Месяц назад
In this video, Mara opens up about her experience as a #digitalnomad and #solopreneur after quitting her cloud solution architect job at Microsoft. Chapters: 00: 00 Intro 01:22 How Mara got started, experience & motivation 03:06 The dry run, test & destination choice 05:10 The sources of income 08:45 Work life balance 14:05 The lifestyle, the good, the bad, the unexpected 30:12 Mara's advice fo...
How to stand out in job applications as solution architects, data engineers, data scientists etc.
Просмотров 92Месяц назад
This is a part of the diary of a solution architect series ruclips.net/p/PLE_IpfSmEJ80dnKUJ3VswZIv7vgo4Cudr in this series, I will cover #jobhunting tips #Interview tips #Skillbuilding Different roles #Careerprogression Productivity tips Life before and after solution architect Hi, I am Liping, Data & AI Solution Architect, ex-Microsoft, I specialize in Big Data Analytics, Data Engineering, Dat...
How to do Databricks Cost Analysis and Cross Charge using Power BI template: customization
Просмотров 1562 месяца назад
#PowerBI Template on #Databricks System Tables for Cost Analysis and Cross Charge Download Power BI template: github.com/lipinght/Databricks-cost-analysis-using-powerbi This video walks you through: How to set up lookup tables How to do root cause analysis How to productionize the template This is part of video series for Power BI template on Databricks system tables for cost analysis and cross...
How to do Databricks Cost Analysis and Cross Charge using Power BI template: Report Navigation
Просмотров 3162 месяца назад
#powerbi template to do #databricks cost management and cross charge Download Power BI template: github.com/lipinght/Databricks-cost-analysis-using-powerbi This video walks you through: How to set up lookup tables How to do root cause analysis How to productionize the template This is part of video series for Power BI template on Databricks system tables for cost analysis and cross charge: rucl...
Welcome to Data Leaps - A channel for #PowerBI #Databricks #platformsecurity #DevOps #Careerindata
Просмотров 1782 месяца назад
Welcome to Data Leaps - A channel for #PowerBI #Databricks #platformsecurity #DevOps #Careerindata
How to publish semantic models to #PowerBI directly from #Databricks workspace, no desktop needed
Просмотров 1,7 тыс.2 месяца назад
How to publish semantic models to #PowerBI directly from #Databricks workspace, no desktop needed
How to do Access Control for #powerbi on #databricks
Просмотров 5523 месяца назад
How to do Access Control for #powerbi on #databricks
How to do Databricks Cost Analysis and Cross Charge using Power BI template: Set Up
Просмотров 6165 месяцев назад
How to do Databricks Cost Analysis and Cross Charge using Power BI template: Set Up
How to configure #powerbi Authentication to #databricks
Просмотров 9335 месяцев назад
How to configure #powerbi Authentication to #databricks
How to choose #databricks connector for #powerbi: Azure Databricks Connector vs Databricks Connector
Просмотров 5455 месяцев назад
How to choose #databricks connector for #powerbi: Azure Databricks Connector vs Databricks Connector
How to acquire data skills(Part 4): How to form #learning habits #data #skills
Просмотров 745 месяцев назад
How to acquire data skills(Part 4): How to form #learning habits #data #skills
How to acquire data skills (Part 3): How to choose #learning resources #data #azure #aws #gcp
Просмотров 736 месяцев назад
How to acquire data skills (Part 3): How to choose #learning resources #data #azure #aws #gcp
How to acquire data skills (Part 2): free #learning resources #data #azure #aws #gcp #databricks
Просмотров 1026 месяцев назад
How to acquire data skills (Part 2): free #learning resources #data #azure #aws #gcp #databricks
How to acquire data skills(Part 1):Top 10 things to spend your development budget on #learning #data
Просмотров 2216 месяцев назад
How to acquire data skills(Part 1):Top 10 things to spend your development budget on #learning #data
How to do OPTIMIZE and VACUUM on #Databricks: DLT, Predictive Optimization, Auto Compaction
Просмотров 3307 месяцев назад
How to do OPTIMIZE and VACUUM on #Databricks: DLT, Predictive Optimization, Auto Compaction
#PowerBI on #Databricks Best Practice: how to do #performance tuning and #security setup
Просмотров 1,5 тыс.8 месяцев назад
#PowerBI on #Databricks Best Practice: how to do #performance tuning and #security setup
10 tech gadgets recommendations for a data professional #productivitytips
Просмотров 3078 месяцев назад
10 tech gadgets recommendations for a data professional #productivitytips
How to use #notion to organise the life of a data professional #productivitytips
Просмотров 3818 месяцев назад
How to use #notion to organise the life of a data professional #productivitytips
How to Connect Power BI to Databricks with Private Link and IP access list #networking #gateway
Просмотров 1,8 тыс.Год назад
How to Connect Power BI to Databricks with Private Link and IP access list #networking #gateway
How to Reduce Power BI Model Size Using Dax Studio #powerbi
Просмотров 508Год назад
How to Reduce Power BI Model Size Using Dax Studio #powerbi
How to Do Power BI Schema Compare and Meta Data Only Deployment Using ALM Toolkit #powerbi #devops
Просмотров 600Год назад
How to Do Power BI Schema Compare and Meta Data Only Deployment Using ALM Toolkit #powerbi #devops
How to Create Partitions in Power BI and Meta Data Only Deploy with Tabular Editor #powerbi #devops
Просмотров 2,8 тыс.Год назад
How to Create Partitions in Power BI and Meta Data Only Deploy with Tabular Editor #powerbi #devops
How to Connect Power BI to Synapse in Managed Vnet #powerbi #synapse #networking
Просмотров 4,2 тыс.Год назад
How to Connect Power BI to Synapse in Managed Vnet #powerbi #synapse #networking
How to Identify Key Factors Behind Your Data in Power BI --Key Influencers #AI #powerbi #aivisuals
Просмотров 318Год назад
How to Identify Key Factors Behind Your Data in Power BI Key Influencers #AI #powerbi #aivisuals
How to Do Root Cause Analysis in Power BI - Decomposition Tree #ai #aivisuals #powerbi
Просмотров 908Год назад
How to Do Root Cause Analysis in Power BI - Decomposition Tree #ai #aivisuals #powerbi
no no
Thanks for sharing, you are sharing useful info on your channel Keep up the good work 👍👍
Great video! Nice call out on the Mac use case. Is there a way to refresh the semantic model (schema and/or metadata changes) once it’s been published?
Yes, you refresh it the same way you would when you publish from desktop
Learn something new! Thanks for sharing. Excellent content!
Did not know this existed! thanks! A lot of Mac Users will love this
Feature is brand new :)
Magic!
This is great!
basically, I can connect to databrick, but I am not able to see system table. however, i can use yout template to see system table and the dashboard
You need access to 3 things: 1. access to system tables. ie. being able to do SELECT * FROM system.billing.usage ( you might need admin to grant you access to the billing schema) 2. access to use the databricks workspace, which you already have, when you say you can connect to Databricks 3. access to a sql warehouse, again, ask admin to give you access, and use the connection string for power bi template
Hello Liping, Thanks so much for your videos, that works for me. but I am not able to setup data connection for system table from PowerBI-》 get the data source, can you give me some idea?
Is there actually a difference between using Azure Databricks Connector within Power Bi as opposed to partner connect? I really can’t see any difference which suggests to use one as opposed to the other?
If your databricks is on azure, there is no difference apart from partner connection pre-populate the connection string for you. If your databricks is on AWS and if you using some other oauth and not AAD, partner connect defaults to Azure Databricks connector and AAD as Oauth, so you are better off connecting manually in Power BI
@@dataleaps yeah mine is Azure. So it’s basically down to preference? Also, do you know if query folding will ever be supported as standard? When connecting to Azure Databricks?
Hi, is there a away to bring source table name???
Hello, iam not getting that custom actions option in tabular editor for single partiton refresh. Please help!
Nicely explained. Thanks for sharing!
Great video! Thank you! I have a large table that is not being refreshed because of premium memory capacity limit. Can I create multiple partitions based on date, and refresh all partitions separately to avoid power BI memory limit issue?
you could do incremental refreshes learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Thanks. But I can’t, because after implementing incremental refresh, the first refresh in power BI service is a full refresh which I get memory capacity error.
@@Amir_mo what's your model size and what power bi capacity are you on?
If you are using AAD with databricks on AWS, you can use the Azure Databricks connector in Power BI as long as you have SSO enabled
*Promosm*
Thank you so much for this. I'm new to Data Analytics and this video has helped me a lot with a project I'm working on
Al momento de intentar realizar el análisis de sentimiento me arroja el siguiente error. Agradecería tu ayuda: Expression.Error: No se puede convertir el valor "[Function]" al tipo Function. Detalles: Value=[Function] Type=[Type]
El error me aparace al conectar una Hoja de Cálculo de Google. No así cuando uso un Excel, ahí no tengo problemas
Just what I was looking for! Really helpful! Thanks a mil :)
The sound of this video was recorded on the right channel. If you cannot hear anything, change your computer sound audio balance and increase the right balance, you will be able to hear better
Voice is very low, no use of video information, its very difficult to hear and understand
The sound of this video was recorded on the right channel. If you cannot hear anything, change your computer sound audio balance and increase the right balance, you will be able to hear better
You forgot to add your voice.
Great!
Not able to hear anything
The sound of this video was recorded on the right channel. If you cannot hear anything, change your computer sound audio balance and increase the right balance, you will be able to hear better
Does the powershell script also work if you have MFA on your account? or is a ServiceAccount some specific account type that you need to create in Azure AD?
Service Principal is not an normal AAD account, you set it up by setting up app reg in AAD, take a look at this github.com/lipinght/PBICookbook/blob/main/ServicePrincipal/ServicePrincipal.md
Very good video. TY
Glad it was helpful!
Really helpful! How's the performance through the gateway approach?
gateway typically ends up being the performance bottleneck
Thank you, it was very clear and useful!
Great to hear! Thanks
Hi, Can we do the similar Power BI Partition refresh using Power Automate? Basically we have to execute the xmla code.
data-marc.com/2020/01/13/manage-all-your-power-bi-refreshes-in-one-place-with-power-automate-flow/
I executed the same script but i am getting the below error used below module Install-Module -Name MicrosoftPowerBIMgmt.Profile -Verbose -Scope CurrentUser -Force Install-Module -Name MicrosoftPowerBIMgmt.Workspaces -Verbose -Scope CurrentUser -Force Install-Module MicrosoftPowerBIMgmt -force -AllowClobber Connect-PowerBIServiceAccount : One or more errors occurred. At D:\a\_temp\2f66e56e-fd4c-4dc0-b011-d2aa4bdd1079.ps1:8 char:1 + Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credenti ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (Microsoft.Power...IServiceAccount:ConnectPowerBIServiceAccount) [Connect-Po werBIServiceAccount], AggregateException + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.ConnectPowerBIServiceAccount
cool
What does forecast bias mean here?
Great Insight. I would like to watch more videos from you often, please do!😊
Thanks for the video and the explanation. At 7:34 for Gateway Connection, is Power BI Premium required? With Power BI Pro its grey out for me.
yes, vnet gateway currently is a premium or premium per user feature, you could alternatively use a on prem gateway instead if you have pro
@@dataleaps Hi, is one PPU enough to set up the gateway? Or do you also need a premium workspace? Cause I can not add pro users to a premium worksapce.
@@TiesKuipers you have use a ppu to set up the vnet gateway, in a ppu workspace, then everyone who access that will need a ppu too