Easy Ways to Refresh Tabular Models | Data Exposed: MVP Edition

Published Mar 30 2021 09:00 AM 847 Views
Microsoft

In this episode with Gaston Cruz, he'll show you the options to process Azure Analysis Services models (Semantic Layer) connecting to an Azure SQL DB as a data source (using SSDT), and then create an architecture using a Service Principal account to process the model (DB, Tables, Partitions) in an automatic way deploying an Azure Logic Apps, and then calling from Azure Data Factory to trigger the process. Finally, he'll conclude by showing you the advantages of using a live connection from Power BI to connect to AAS models.

Watch on Data Exposed


Resources:

View/share our latest episodes on Channel 9 and YouTube!
%3CLINGO-SUB%20id%3D%22lingo-sub-2220818%22%20slang%3D%22en-US%22%3EEasy%20Ways%20to%20Refresh%20Tabular%20Models%20%7C%20Data%20Exposed%3A%20MVP%20Edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2220818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIn%20this%20episode%20with%20Gaston%20Cruz%2C%20he'll%20show%20you%20the%20options%20to%20process%20Azure%20Analysis%20Services%20models%20(Semantic%20Layer)%20connecting%20to%20an%20Azure%20SQL%20DB%20as%20a%20data%20source%20(using%20SSDT)%2C%20and%20then%20create%20an%20architecture%20using%20a%20Service%20Principal%20account%20to%20process%20the%20model%20(DB%2C%20Tables%2C%20Partitions)%20in%20an%20automatic%20way%20deploying%20an%20Azure%20Logic%20Apps%2C%20and%20then%20calling%20from%20Azure%20Data%20Factory%20to%20trigger%20the%20process.%20Finally%2C%20he'll%20conclude%20by%20showing%20you%20the%20advantages%20of%20using%20a%20live%20connection%20from%20Power%20BI%20to%20connect%20to%20AAS%20models.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F2it5bsFFQiA%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCFa1TrY_1pCgXSsjX8fAetw%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EGaston's%20YouTube%20Channel%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fanalysis-services%2Fanalysis-services-async-refresh%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAAS%20REST%20API%20official%20doc%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CBR%20%2F%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2220818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20how%20to%20use%20Azure%20services%20to%20automate%20the%20tabular%20models'%20process.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2220818%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Mar 18 2021 11:48 AM
Updated by: