Importing data into excel using power query RRS feed

  • Question

  • Hi,

    I am trying to import data into excel 2013 using power query. I connect to the oracle DB and pull data through a view defined in the oracle DB. The view column has been defined for example as

    create or replace view example


    select column1 as "column one", column2 as "column two" from table;

    When i have the alias of the column names having spaces and within inverted commas i get an apostraphe added to the last column and its values in the excel sheet after i ran the power query referring to a query of the above type.

    How do we overcome this issue?


    Wednesday, June 14, 2017 10:12 PM