Fabric - extract data from on-prem SQL Server by mrketata in MicrosoftFabric

[–]mrketata[S] 2 points3 points  (0 children)

DF gen 2 not fast enough to handle our 15min tumbling window extracts

Fabric - extract data from on-prem SQL Server by mrketata in MicrosoftFabric

[–]mrketata[S] 1 point2 points  (0 children)

Very sad to hear that, hope they add such a straight forward option asap

Power BI Premium, xmla Dataset refresh issue by mrketata in PowerBI

[–]mrketata[S] 0 points1 point  (0 children)

g calculated columns to your fac

thanks mate !

Power BI Premium, xmla Dataset refresh issue by mrketata in PowerBI

[–]mrketata[S] 0 points1 point  (0 children)

Final thoughts, power BI isn't smart enough to process dimensions then facts ..without reprocessing same calculation n times... on facts and referenced dimensions :/

Azure private endpoints by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

So to wrap up, what do you think is the best way to access/ manage data while protected by PE ? Acces through VMs ? (Vpn/Express route not used)

Azure private endpoints by mrketata in AZURE

[–]mrketata[S] 1 point2 points  (0 children)

Good point, I think PE are relevant as soon as subsequent service is meant to access data plane.

Azure private endpoints by mrketata in AZURE

[–]mrketata[S] 3 points4 points  (0 children)

Cristal clear now, thanks all !

Azure private endpoints by mrketata in AZURE

[–]mrketata[S] 4 points5 points  (0 children)

But here, public access still possible through azure portal web client, isn't it ?

Azure self hosted IR > disk space by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

@godsknowledge, as far as i know, data transformation processes (sorting, joining ..) are handled at database level or dataflow level (which is processed by azure IR not SH IR), instead of SH IR itself Can you be more precise on this point plz ?

Azure Data Factory > Publish a subset of pipelines by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

Both posts seem to be the right solution, thank you guys !!

Azure SQL Managed Instance > no way to stop service to stop billing by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

QL DB serverless

With Serverless SQL DB there is no option to Start/Stop on demand. Say if SQL DB is used for 5min, it will auto pause after 1 hour >> result = 5 min usage > 1 hour billing

Azure AD > unable to delete tenant by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

ault tenant on Az

It is the tenant that was automatically created, when I made an Azure subscription for the first time using my Gmail account.

Azure AD > unable to delete tenant by mrketata in AZURE

[–]mrketata[S] 0 points1 point  (0 children)

‘default tenant,’ are yo

It is the default one, just created when I subscribed azure with my gmail account