Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
DataSource.Error: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host " server" and accepting
TCP/IP connections on port ?
Details:
DataSourceKind=AmazonRedshift
DataSourcePath=
OdbcErrors=Table
HI @chotu27,
I think this issue may related to connector/driver configuration, If you test ODBC driver with UDL file, did it works?
Creating a Microsoft Data Link file (UDL) for Connecting to a Database in LabVIEW
If your connection also not works in UDL test, I'd like to suggest you to double check your configuration/settings and choose correct one to try again.
After finish testing, you can open UDL file to get correct connection string.
Use a UDL file to create connection string
BTW, current power query support use parameter to dynamic change data source. When load data and generate table, original table structure will cached in query steps, if new structure can't correspond with original one(after using parameter to change datasource), power bi will return error.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
94 | |
79 | |
76 | |
64 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |