0

I'm trying to connect to a SQL Server database with the On-Premise Data Gateway, but unfortunately I have a period in the name of the database (yes, I know it's a bad idea). The gateway will successfully connect to databases without a period in the name, but I can't escape the name.

For instance:

Database name: Foo.Fighters I've tried [Foo.Fighters] and "Foo.Fighters" in the Database field with not luck.

As soon as I change it to a different DB on that same server, we're all good.

Any thoughts that aren't, change the name of the DB?

Mark Rullo
  • 119
  • 10
  • I believe there's something called database synonyms for this in SQL Server. – evilSnobu Aug 08 '18 at 15:07
  • That's a really good thought, I just confirmed that synonyms are only for specific objects. For example, tables, stored procedures, etc. – Mark Rullo Aug 08 '18 at 15:18
  • Can you use SMSS to connect to Foo..., from its dropdown? Is there a subtle spelling difference? When using SQL what is the error message? Server version year? – donPablo Aug 08 '18 at 15:44
  • Look at the error messages here, and the logging capabilities...https://learn.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot – donPablo Aug 09 '18 at 18:30
  • Thanks for the comments. I can connect via SSMS, but not with the Add A Data Source button in PowerBI. As soon as I change the name of the database to something the doesn't have a period in it, it works, but that's not helpful when I need to connect to [Foo.Fighters] – Mark Rullo Aug 10 '18 at 17:46
  • 1
    Try opening an issue here, hopefully it will signal the Power BI product group - https://github.com/MicrosoftDocs/powerbi-docs/issues?utf8=%E2%9C%93&q=%2212a87ce1-0e1b-f21c-bad3-09963e628d99%22&in=body. Looks like a bug to me so it should be fixed upstream. – evilSnobu Aug 14 '18 at 06:48

0 Answers0