sisalindri

You have the flexibility to import data from wide variety of supported databases. You can also run a native database query, which can save you the time it takes to create the same results in Power Query.    Warning:  If you run a Native Database Query written by another user, you are prompted to ensure that you're aware of the queries that will be evaluated with your credentials. Enter a native database query You can specify a native database query in the SQL Statement box when connecting to a database. In the example below, we import data from a SQL Server database by using a native database query. The procedure is similar all other supported databases. Select Data > Get Data > From Databases >  From SQL Server Database. The SQL Database dialog box appears. Specify the Server and Database from whe...

Data Type     Date Entry Type     Calculated Description     For each task that has a deliverable associated with it, the Deliverable Start field displays the scheduled start date of that deliverable. For tasks that have no associated deliverable, this field displays a value of NA . How Calculated     The Deliverable Start field displays the text that appears in the Start field for the associated deliverable. This date cannot be changed manually on the task sheet. To change this date, click Manage Deliverables on the Collaborate menu, and then make your changes in the Deliverables pane. Note:  Some deliverables use the Title (Name), Start, and Finish values of the tasks that produce them. Making changes to the values in the Deliverables pane does not automatically make the same changes to the associated task. Best Uses     Add the Deliverable Start field...