Post reply

Query Mode section under Deployment Options not available

  • November 24, 2018 at 12:17 am

    #380942

    Hi everyone,

    Recently I have been experiencing an issue with SSDT that I could not find a solution for: 
    My problem is, in SSDT Tabular, when I go to project properties there is no Query Mode section under Deployment Options.

    My set up is:
    Visual Studio 2017 Community Edition 15.7.6
    SSAS 2017  Developer Edition in Tabular Mode
    Model in DirectQuery Mode
    Workspace server: Integrated Workspace

    Thanks
    FT

  • November 24, 2018 at 8:28 am

    #2014423

    fatihtuncay - Saturday, November 24, 2018 12:17 AM

    Hi everyone,

    Recently I have been experiencing an issue with SSDT that I could not find a solution for: 
    My problem is, in SSDT Tabular, when I go to project properties there is no Query Mode section under Deployment Options.

    My set up is:
    Visual Studio 2017 Community Edition 15.7.6
    SSAS 2017  Developer Edition in Tabular Mode
    Model in DirectQuery Mode
    Workspace server: Integrated Workspace

    Thanks
    FT

    IIRC, the query mode is a top level property of the project, one cannot change those options after creating the project.
    😎
    In simple terms, one either creates a pass-through or a local (contained) query, the latter requiring the import and processing of the data as a prerequisite to to queries execution.

  • November 24, 2018 at 11:15 pm

    #2014435

    Thanks for your reply Eirikur. I was referring to this property (might not be available for SSAS 2017, I'm not sure):

  • November 25, 2018 at 2:16 am

    #2014437

    Check the properties for the project's .bim file in the Solution explorer, there should be a DirectQueryMode setting, either on or off.
    😎

  • November 27, 2018 at 12:59 am

    #2014601

    I have that setting there but it's not in the project properties as shown in the picture in my post. Has that been removed since SQL Server 2017?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply