Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello !!
I'm trying to set up the Enterprise Gateway, my database is configured with Binary collation, and i put the database name in uppercase, but the system returns the error below, with the database name in lowercase. I'm trying to make this with a database with lowercase name and it work,
Bug ???
"Underlying error message: Cannot open database "dadosadvmp8"
requested by the login. The login failed. Login failed for user ...."
Thanks !!
If lowercase/uppercase switch changes the issue, it is 100% a bug. I had a similar experience with the early SSAS Connector, it was also case sensitive.
After 15 days waiting a support ticket, no solution until now !!!
I'm seeing the same thing - results in login failed, with binary collation on for the target db
A workaround for this problem: create a database with a lowercase name, use this database for connection in gateway. But when creating the data source, use sql query to get the data from an especific database:
SELECT *
FROM [DATABASE].[dbo].[TABLE]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |