Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
1. My reports and mySQL refreshes in Power BI "Desktop" work fine.
2. I am uploading my report to app.powerbi.com, and need to schedule a refresh to my
"On-premises data gateway (personal mode)" [let's not get into why I am using personal mode right now. It's the latest as of June 6 2018)
3. When you go to "Data Source Credentials" under "Datasets", I have maybe 25 mySQL DB's I need to provide login and password for. 5 DB's may be on Server A, 8 DB's on server B, etc.
4. I have DB's on Server A and C that connect without issue. However, I have DB's on server B that timeout over and over again.
pic... https://screencast.com/t/EdVtUY3e5K7B
Why? The big mystery:
I did some detective work and found out that when trying to connect, Power BI runs this query...
select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, CREATE_TIME AS CREATED_DATE, UPDATE_TIME AS MODIFIED_DATE, TABLE_COMMENT AS DESCRIPTION
from information_schema.TABLES
If anyone else has ideas or a solution, HELP!!!. I'm dead in the water going to production because of a login timeout!
Here is a video with more info...
https://screencast.com/t/SQasrsKdJFI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.