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.
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.