- 6
- 7 265
Kevin Arnold
เข้าร่วมเมื่อ 24 เม.ย. 2014
Importing SQL DB Definitions to PBIX
Here is a method to import definitions from a SQL DB into your Power BI model.
***Connect with me on twitter - kevarnold
Links:
- Guy in a Cube Question in chat - th-cam.com/video/2nzANkTY4IY/w-d-xo.html
- TE Scripts - docs.tabulareditor.com/te2/Useful-script-snippets.html#export-object-properties-to-a-file
- My Files - github.com/kevarnold972/blogshare/tree/master/Importing%20SQL%20DB%20Definitions%20to%20PBIX
- Adding Extended Properties - learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addextendedproperty-transact-sql?view=sql-server-ver16
- Limits on updating PBIX Tables - github.com/TabularEditor/TabularEditor/issues/1039
***Connect with me on twitter - kevarnold
Links:
- Guy in a Cube Question in chat - th-cam.com/video/2nzANkTY4IY/w-d-xo.html
- TE Scripts - docs.tabulareditor.com/te2/Useful-script-snippets.html#export-object-properties-to-a-file
- My Files - github.com/kevarnold972/blogshare/tree/master/Importing%20SQL%20DB%20Definitions%20to%20PBIX
- Adding Extended Properties - learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addextendedproperty-transact-sql?view=sql-server-ver16
- Limits on updating PBIX Tables - github.com/TabularEditor/TabularEditor/issues/1039
มุมมอง: 107
วีดีโอ
Confusing Line and Column Chart Visual Default Behavior
มุมมอง 122 ปีที่แล้ว
The Line and Column charts in #PowerBI can sometimes cause confusing charts. I will explore why that happens and how to work around it. I submitted an Idea to change this behavior. Please vote at - ideas.powerbi.com/ideas/idea/?ideaid=3259f084-8e79-ec11-b820-0003ff4569ae Connect with me on twitter - kevarnold
A look into pbi tools to extract changes to a PBIX file
มุมมอง 4682 ปีที่แล้ว
The PBI-Tools software can extract the objects in your PBIX file. This will allow you to compare extracts after changes to help with code reviews. The tool can do much more, which is documented on the links below. NOTE: there was a new release of the tool after the recording and before the publishing of this video. github.com/pbi-tools/pbi-tools pbi.tools/cli/
MS 365 Developer - Adding Sample Users
มุมมอง 1.4K3 ปีที่แล้ว
This is the 2nd video in my series on using the Microsoft 365 Developer program. This will cover setting up the sample users on your tenant. #PowerBI #PBI #BusinessIntelligence References - - Microsoft 365 Developer Program - developer.microsoft.com/en-us/microsoft-365/dev-program Connect with me on twitter - kevarnold
Free Microsoft 365 License - Series Intro and setup
มุมมอง 993 ปีที่แล้ว
This is the first video in my series on the Microsoft 365 Developer program. This will cover setting up your subscription to get started. We will work toward using it with #PowerBI in future videos. #PowerBI #PBI #BusinessIntelligence References - - Microsoft 365 Developer Program - developer.microsoft.com/en-us/microsoft-365/dev-program - Outlook Email account - outlook.com - Curbal video on 3...
Generating Bus Matrix documentation
มุมมอง 5K3 ปีที่แล้ว
Adding a business matrix to your data model documentation. #PowerBI #PBI #BusinessIntelligence References The Kimball Business Matrix - www.kimballgroup.com/1999/12/the-matrix/ Two Alex Documenting Power BI - th-cam.com/video/eUiSVGoMnPA/w-d-xo.html&t Tabular Analyzer Github - github.com/kevarnold972/Tabular-Analyzer Connect with me on twitter - kevarnold
Thanks!
Thanks for the demo
This is compelling... I wonder what that next step is though for getting the table descriptions in there... surely there MUST be a way...
I think it requires MS to support table level changes. I agree there must be a way. I will provide an update if I find something
Thank you, your video is very helpful. "Bus matrix short for a Business matrix."
it may usefull for me, thks
Thank you Kevin, followed the instructions and this is incredibly useful. Much appreciated.
Glad it helped