Skip to main content

Vote (0) Share
's profile image

on

Comments (0)
's profile image Profile Picture

ash ketchum on 24 Aug 2024 16:23:50

RE:

>

's profile image Profile Picture

ash ketchum on 24 Aug 2024 16:22:16

RE:

'/*\'/*"/*\"/*

's profile image Profile Picture

ash ketchum on 24 Aug 2024 16:21:37

RE:

">

's profile image Profile Picture

ash ketchum on 24 Aug 2024 16:17:16

RE:

's profile image Profile Picture

ash ketchum on 24 Aug 2024 16:16:28

RE:

's profile image Profile Picture

Suraj Magdum on 24 Aug 2024 08:41:54

RE:

Let’s clarify it further building a Data Warehouse based on an Azure SQL DB with shortcut the enhanced approach using Microsoft Fabric:Assume Scenario: We have an application that stores data in an Azure SQL DB. Unfortunately, creating additional DB objects (such as views or stored procedures) within this database is restricted.To build a Data Warehouse based on the Application DB we have below options  Traditional approach Option 1: it need to transform the data into dimensional model and load it into independent Data Warehouse which in-turn additional efforts and resources needed.Traditional Approach Option 2 (Linked Server):Create a linked server to the Application DB from a new database server. Use views or stored procedures to transform the data into a dimensional model.However, this approach has limitations, including potential performance bottlenecks and security concerns.To enhanced approach using Microsoft Fabric: Replace the linked server with Microsoft Fabric (a modern alternative).Create a shortcut of application database into the new Data Warehouse or Data Lake. This shortcut provides read-only access to existing objects in the Application DB.Leverage Fabric features to efficiently transform application data into a dimensional model with additional security layer.Enjoy the benefits mentioned in the original idea.

's profile image Profile Picture

Seyoung Jung on 23 Aug 2024 21:47:02

RE:

Is there a workaround to bold values in a specific column at least??

's profile image Profile Picture

Beth Zapadka on 23 Aug 2024 21:38:42

RE:

Fully agree with the request and prior comments. This would be very useful and is a standard offering in other ERP software.

's profile image Profile Picture

Arpad Gerber on 23 Aug 2024 18:33:25

RE:

I totally agree!

's profile image Profile Picture

Roger Friederich on 23 Aug 2024 18:29:48

RE:

Looks like it is not allowed to post links to AppSource here.Search for "DYCE Project Billing" in AppSoruce. This app enables what you are looking for (and much more)