Forum Discussion

roboskoog's avatar
roboskoog
Frequent Visitor
10 years ago

Reading Sql Server tables and getting Invalid Object Name errors

I am trying to Read to a Sql Server DB using Power BI Desktop.  I have successfully connected and read other SQL Server DB’s with Power BI.  I can connect to this DB and see the tables in the DB but when I try to read any table, I get the following Error messages and no data is returned.

 

Invalid object name 'sys.objects'.

Invalid object name 'sys.schemas'.

Invalid object name 'sys.columns'.

Invalid object name 'sys.types'.

Invalid object name 'sys.types'.

Details:

    DataSourceKind=SQL

    DataSourcePath=144.10.139.184;QODB

    Message=Invalid object name 'sys.objects'.

Invalid object name 'sys.schemas'.

Invalid object name 'sys.columns'.

Invalid object name 'sys.types'.

Invalid object name 'sys.types'.

    Number=208

    Class=16

Anyone else getting this or know how to fix it??

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    roboskoog Is this SQL database different than others? Version, edition, etc?

    Do you get the same error if write a query to select the information from the tables?

    • roboskoog's avatar
      roboskoog
      Frequent Visitor
      10 years ago

      I believe it is the same version of Sql Server.  I just tried to write a query and that seemed to work, but if I select a view in the database, I get the same error.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        roboskoog I've never seen the error, but a quick search brought up a similiar looking error written about by Adam Saxton here

        The other thing I would check is that you have the same permissions on this database that you have on the other.