Forum Discussion
Dataflow and PowerBI Gateway - Sourcing data dynamically
Hi all, I have a Dataflow Gen2 which is sourcing data from an on-premises SQL Server via PowerBI Gateway. The server contains many databases, each representing a retail POS. These databases may...
Hi Element115
I gather that I will be able to use the M "sql.databases" function to acquire the details of the databases that I need to access, so no additional metadata tables should be necessary.
I do appreciate the time and thought you have taken to respond to this query. I am open to any further comments you may have to offer. 🙂
Thanks and regards
Interesting! You're right, that should do the trick. I was not aware M had such a function. Pretty nifty. 😊