Forum Discussion

cevipu's avatar
cevipu
New Member
8 years ago

PowerPivot import with oracle.oledb data source converts to teradata

Hi,

I try to import an Excel PowerPivot with oracle.oledb dataprovider to PBI desktop, but strangely the queries are transformed as a Teradata source.

---------------------------------------

let
    Source = #!" let#(cr)#(lf)    Source = Teradata.Database

---------------------------------------

 

The PowerPivot workbook refreshes succesfully and is configured to use oracle oledb provider.

 

Other PowerPivot workbooks are imported succesfully, but not this one. What could be the reason?

 

4 Replies

  • cevipu's avatar
    cevipu
    New Member
    8 years ago

    Hi,

    I try to import an Excel with Oracle.oledb provider to Power BI Desktop and for some reason it gets translated to a Teradata source. In Advanced Editor it query starts with:

    ----------------------

    let
        Source = #!" let#(cr)#(lf)    Source = Teradata.Database(""

     

    -----------------------

    In the imported power bi desktop file there are no data sources in the file, when looking at the data sources. In PowerPivot the data refresh and the connections work.

     

    Other power pivot workbooks are imported normally with Oracle source.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI cevipu,

       

      Can you please share more detail contents? (e.g. query,screenshots) It will be help for clarity your scenario.
      In addition, you can try remove 'Source = #!" let#(cr)#(lf)' and test again.

       

      Regards,

      Xiaoxin Sheng

      • Raja1749's avatar
        Raja1749
        Frequent Visitor
        8 years ago

        Hi,

         

        I too facing the same issue, could you please let me know if any one find solution?

         

        Thanks,

        Raja Sekhar