Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power Query in SSIS Invalid Literal

  • 1.  Power Query in SSIS Invalid Literal

    Bronze Contributor
    Posted Aug 14, 2019 09:58 PM
    Getting this error and not sure why. I think it's cause the source has more than 250 columns.

    Query error The value of the property 'SingleQuery Text' is not a valid q uery" Invalid literal. Start position:

    ------------------------------
    Allan Blain
    Project Manager
    ------------------------------


  • 2.  RE: Power Query in SSIS Invalid Literal

    Bronze Contributor
    Posted Aug 15, 2019 09:52 AM
    What type of data source are you using? ​

    ------------------------------
    Michael Foss
    Functional/Business Systems Analyst
    ------------------------------



  • 3.  RE: Power Query in SSIS Invalid Literal

    Bronze Contributor
    Posted Aug 15, 2019 11:20 AM
    Just excel I tired both the 97-2003 version and the current Office 365 version.

    ------------------------------
    Allan Blain
    Project Manager
    ------------------------------