none
table import wizard query result window empty

    Question

  • When previewing a query in the table import wizard column headings are returned in the query results window but no rows of data are returned.

    When I finish and import the data into Powerpivot data is displayed as expected.

    If I log onto a different machine data is displayed in the query results windows.

    Any idea what might be causing no data to be returned in the query results window?

    Thanks

    Monday, July 16, 2012 4:37 PM

Answers

  • When previewing a query in the table import wizard column headings are returned in the query results window but no rows of data are returned.

    When I finish and import the data into Powerpivot data is displayed as expected.

    If I log onto a different machine data is displayed in the query results windows.

    Any idea what might be causing no data to be returned in the query results window?

    Thanks

    Hi James,

    It was an odd question in this case. I need your help to collect the following information, so I will try to reproduce this issue on my test environment.

    • What's the version of your SQL Server PowerPivot for Excel?
    • What's your data source? SQL Server, SSAS cube or other?
    • How many records will return on "Table Import Wizard" window?
    • Please also provide your computer detail information, such as memory, third part applications.

    Regards,


    Elvis Long
    TechNet Community Support

    Monday, November 25, 2013 7:50 AM

All replies

  • James,

    Is this still an issue?

    Thanks!


    Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Sunday, November 24, 2013 5:33 AM
  • yes 
    Sunday, November 24, 2013 11:43 AM
  • When previewing a query in the table import wizard column headings are returned in the query results window but no rows of data are returned.

    When I finish and import the data into Powerpivot data is displayed as expected.

    If I log onto a different machine data is displayed in the query results windows.

    Any idea what might be causing no data to be returned in the query results window?

    Thanks

    Hi James,

    It was an odd question in this case. I need your help to collect the following information, so I will try to reproduce this issue on my test environment.

    • What's the version of your SQL Server PowerPivot for Excel?
    • What's your data source? SQL Server, SSAS cube or other?
    • How many records will return on "Table Import Wizard" window?
    • Please also provide your computer detail information, such as memory, third part applications.

    Regards,


    Elvis Long
    TechNet Community Support

    Monday, November 25, 2013 7:50 AM