ahdatabase's profile picture. Passionate about #Data, #BusinessIntelligence and #Analytics. Experienced PowerBI, SQL Server, SSIS developer -available (good rate) for London and South of M25

Aktha

@ahdatabase

Passionate about #Data, #BusinessIntelligence and #Analytics. Experienced PowerBI, SQL Server, SSIS developer -available (good rate) for London and South of M25

Aktha reposted
kurtbuhler's tweet image.

Video shows usecase for both the lakehouse and sql datawarehouse in same project. Incremental load of the fact table (resides in DW) and complete load of the dimension tables (resides in lakehouse) and directlake to #powerbi youtube.com/watch?v=B4zi6e… thanks @amitchandak78 and Ryan

ahdatabase's tweet card. Microsoft Fabric - Incremental ETL

youtube.com

YouTube

Microsoft Fabric - Incremental ETL


if you create a view in MS Fabric datawarehouse , can you view the underlying query? Google Gemini: No, you cannot directly view the underlying query for a view created in #MSFabric data warehouse... you can't access the original logic used to construct the view. - disappointing


Aktha reposted

My first performance tests on #Fabric Direct Lake vs Import mode ❄ Cold cache: DAX queries are ~ 20% faster in Import than Direct Lake. 🔥 Hot cache: DAX queries have very similar performance. Obviously each semantic model is different... but do you also see the same trend ?

Datatouille's tweet image. My first performance tests on #Fabric Direct Lake vs Import mode

❄ Cold cache: DAX queries are ~ 20% faster in Import than Direct Lake.
🔥 Hot cache: DAX queries have very similar performance.

Obviously each semantic model is different... but
do you also see the same trend ?

Am i right in understanding that you can not create shortcuts in a #MSFabric #lakehouse to directly access PAAS sql server tables ? So you need complex work-around to make it happen . A workaround blogged by @DataMozart : data-mozart.com/rule-them-all-… #PowerBI


..looking at #Fabric . Can #Lakehouse #DirectLake replace microsoft #sqlServer as my favorite datasource for #powerbi ? The sql analytic endpoint in #MSFabric is brilliant - but will the limitations be overcome? please post any blog links below.


when migrating your #powerbi to #msfabric environment, should you create a new lakehouse For every #powerbi report in the workspace? (note scenario here is there is no shared datasets involved) I suspect the answer would be no, so what is the best practice ?


why skill up on #MSFabric: *#MSFabric is a lake-centric solution. OneLake, *DirectLake, Data Mesh architecture *entirely PAAS *Centralized administration, security , governance *mix of Low-code (end user) + Pro code *DirectLake - For #powerbi as good as import performance (maybe)


connect power bi premium workspace to MS SQL Management Console ..copy the Workspace Connection string from the premium tab of workspace setting , and then paste in the sql management console analysis service engine . Have fun! #powerbi

ahdatabase's tweet image. connect power bi premium workspace to MS SQL Management Console ..copy the Workspace Connection string from the premium tab of workspace setting , and then paste in the sql management console analysis service engine .  Have fun!  #powerbi

Aktha reposted

I announced this morning at the #FutureDataDrivenSummit the public preview of the free #azuresql database offer. Try it out yourself at aka.ms/freedboffer.

bobwardms's tweet image. I announced this morning at the #FutureDataDrivenSummit the public preview of the free #azuresql database offer. Try it out yourself at aka.ms/freedboffer.

Is it possible for #PowerApps to handle a asynchronous response coming from a Power Automate flow? This is so to avoid power app failure due to flow taking more then 2-3 minutes on an azure ADF related work. my internet search is not finding anything useful.


star schema qn #powerbi: if your facts are descriptive comments (eg 500 characters) along with numerical values and measures associated to the comments ..do you keep them both in the same fact table ? #dimensionmodelling


comparing #AzureSynapse #Databricks - 2 easy read blogs for those new to the technologies: endjin.com/blog/2020/05/d… written in 2020 and adatis.co.uk/databricks-vs-… writtent in May 2022 I think I will be heading towards azure synapse analytics for personal development


United States Trends

Loading...

Something went wrong.


Something went wrong.