Forum Discussion

AusSam74's avatar
AusSam74
Frequent Visitor
9 years ago

SQL database names missing with DQ - syntax to let source direct?

Hi, I am trying to access a table on a database in SQL.

 

The syntax I am using is the following -

 

 

let
Source = Sql.Database("SERVERNAME", "DATABASE NAME"),
dbo_TABLENAME= Source{[Schema="dbo",Item="TABELNAME"]}[Data]

in

dbo_TABLENAME

 

But the error keeps appearing saying the following:

 

"unable to connect: "Microsoft SQL: Incorrect syntax near '='."

 

The only thing is that this database is setup in SQL under Synonyms not under TABLES.

 

I can see the TABLES when I try to access this database but the not the tables under synonyms, that is why I am trying to access this table direct with DX - any help please?

 

THKS.

 

Samir.

 

 

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    AusSam74

     

    Power BI uses ADO.net provider to retrieve data from SQL Server, it only supports Tables/Views, Scalar functions, Table functions. See: Power BI Data Source Prerequisites.

     

    However, Synonyms can be created for many objects like stored procedures, CLR functions, etc. See: Synonyms (Database Engine). Data Provider can't determine the type of the database objects under Synonyms. So you can't connect Synonyms directly in Power BI Desktop.

     

    Regards,