RULE 'EM ALL! Create OneLake shortcuts to ANY data source!
Рет қаралды 818
5 ай бұрынOneLake shortcuts! They are super cool, right? But, shortcuts are supported only for other #MicrosoftFabric items, such as lakehouses, plus ADLS Gen2, Amazon S3, and Dataverse...We can't create shortcuts to on-prem data sources, such as SQL Server, right? RIGHT?!
Well, yes and no! In this video, I explain how to create "shadow shortcuts" to any data source that is part of the #powerbi semantic model. And, when I say any, I mean literally any - not only SQL Server tables or Excel files, but also something as wild as DAX calculated tables!
Link to article: data-mozart.com/rule-them-all...
Learn with Data Mozart: learn.data-mozart.com/
@Nalaka-Wanniarachchi 5 ай бұрын
Very nice ,nikola !!!
@DataMozart 5 ай бұрын
Thanks mate👍
@user-ws7ey8pq6j 5 ай бұрын
great video! One question: how can we use powerBI desktop to work with Direct Lake? Currently it is not allowed, but are there any workarounds to it? Lets say I have an existing report based on ADLS Gen2. If I do the shortcut to One Lake and use SQL endpoint to replicate it and publish it with Import mode, can it be switched to use direct lake instead? Or do I have to re-create measures, data model, visuals etc in powerBI service from scratch in order to use Direct lake connection? Thanks
@DataMozart 4 ай бұрын
Hi. As far as I know, Direct Lake is not working (yet) with Power BI Desktop. Hm, I'm not sure that the workaround you mentioned could work, because I believe you can't switch from import to Direct Lake. Cheers!
@reach2puneeths 3 ай бұрын
Can we create shortcut to Oracle database from fabric?
@DataMozart 3 ай бұрын
No, at this moment it's still not available.
@reach2puneeths 3 ай бұрын
Thanks for quick response
Data Mozart
Рет қаралды 1,3 М.
Go Gizmo!
Рет қаралды 27 МЛН
Myphoneacc
Рет қаралды 11 МЛН
Cord & Wire
Рет қаралды 4,5 МЛН