Hi! Do we always need to publish the semantic model whenever there a (data) change? Is it possible to automatically reflect any (data) changes on the semantic model in the shortcut?
Hi, it depends if you use Import/Direct Query/Direct Lake storage mode for semantic model. For Import mode, you must refresh semantic model to have the latest data from the data source. For Direct Query, it's not necessary, because queries will be generated at the query time and will always retrieve the latest data from the data source. For Direct Lake, you can enable "refresh" (data reframing) under settings "Keep your Direct Lake data up to date". If you are interested to learn how refresh works in Direct Lake, I wrote a blog post some time ago: data-mozart.com/50-shades-of-direct-lake-everything-you-need-to-know-about-the-new-power-bi-storage-mode/ Hope this helps
@@DataMozart Hi, I'm testing this process, but the export command (in the SSAS) do not create the parquet delta files for "direct query tables" from the semantic model. It creates the parquet delta files for the "import tables", and from there we can create the shortcut. Is this also happening to you or are you able to create the delta files for "direct query tables"?
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
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!
Very nice ,nikola !!!
Thanks mate👍
Hi! Do we always need to publish the semantic model whenever there a (data) change? Is it possible to automatically reflect any (data) changes on the semantic model in the shortcut?
Hi, it depends if you use Import/Direct Query/Direct Lake storage mode for semantic model. For Import mode, you must refresh semantic model to have the latest data from the data source. For Direct Query, it's not necessary, because queries will be generated at the query time and will always retrieve the latest data from the data source. For Direct Lake, you can enable "refresh" (data reframing) under settings "Keep your Direct Lake data up to date". If you are interested to learn how refresh works in Direct Lake, I wrote a blog post some time ago: data-mozart.com/50-shades-of-direct-lake-everything-you-need-to-know-about-the-new-power-bi-storage-mode/
Hope this helps
@@DataMozart Thanks
@@DataMozart Hi, I'm testing this process, but the export command (in the SSAS) do not create the parquet delta files for "direct query tables" from the semantic model. It creates the parquet delta files for the "import tables", and from there we can create the shortcut. Is this also happening to you or are you able to create the delta files for "direct query tables"?
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
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!
Can we create shortcut to Oracle database from fabric?
No, at this moment it's still not available.
Thanks for quick response