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

[AusSam74]

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.

[v-sihou-msft]

@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,