Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I built a Power Query Source = sql.databases("SERVERNAME"). It returns all DBs on the server, and all DBs share an idential schema. I filter & expand to get the same table across all DBs, and see all checked out files. This works great in PBI desktop, and I can publish the report without issue.
When I go to add the gateway connection, I'm forced to select a single DB on the server, and I cannot map the connection between my data source, and the gateway. I've tried using "*"," ","master","null", and other combos, but nothing works. Is this possible? Screenshots attached...
Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.