Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
With the September release of Power BI Desktop, our ability to load tables one-by-one appears to have stopped working.
We have a connection to an outside RedShift data warehouse that has connection limits. If we were to try to load all the tables we need into Power BI in parallel, we would receive a "Too many connections" error thrown from the RedShift side. To work around this, we deselect the "Parallel Loading of Tables" option in Options > Data Load to allow us to load one table at a time.
However, after updating to the September 2018 release, this option seems to be stuck on Enable (the visual check box is working, but not the underlying functionality).
We have only a single project connected to this RedShift instance so there isn't a conflict with other programs/projects trying to access at the same time, which could throw the "Too many connections" error.
We have also tested our connection with a SQL editor separately and it's connecting as expected.
The only variable that has changed to this project is the update to the new release,
If there is any more information I can provide, please let me know.
Thanks!
-Ben
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.