Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

PBI won't connect to SQL Server table

hi community,  I'm new to PBI and I either I'm missing something fundamental or this thing is really buggy.  I can't even connect to a SQL Server 2008 table.   As I try and connect to the table it says the column can't be found. 

 

 

Here's the script fro mthe advanced editor

 

let
    Source = Sql.Databases("qlikview.dk.sql.group.icopal.git"),
    IproBis = Source{[Name="IproBis"]}[Data],
    dbo_SA_CUSTOMER = IproBis{[Schema="dbo",Item="SA_CUSTOMER"]}[Data]
in
    dbo_SA_CUSTOMER

 

 

I've tried it for a single field but I get the same error.  Some help would be appreciated. 

 

Thanks in advance

Mark

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous What is the data type of the column? And are you trying to import or direct query? Do you get this error if you script out a SQL query instead of selecting the table?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      hey, haven't tried manually scripting it but the data type is nvarchar.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Anonymous K, there should be no issues there. Try a direct script, or create a quick view to reference.

        The only references to this error that I have seen relate to something being done in Power BI where the column is still referenced, but no longer exists in the data set. This is an oddity, are you on the latest version of Power BI Desktop?