Forum Discussion
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="...
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,