Phone:

Techtalks: Traveltech

image placeholder
Vivek Garg

asked  Oct 7, 2022

Windows Server 2008 Tableau Desktop 7.0 Local MySQL database using Xampp

When attempting to connect to a localhost MySQL database server using the native MySQL data connection in Tableau Desktop, I'm getting the following error:

"The connection to the data source might have been lost. Communication with the Tableau Protocol Server process was lost.

Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database. Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database."

When using "Other Databases (ODBC)" in Tableau, I am able to connect and return data. However, I would prefer to use the MySQL connection to avoid the limitations of the Other Databases connection.

I created a specific username in phpmyadmin as well as tried using the root username and password and the same error was returned. I created a user DSN in odbcad32.exe and attempted using multiple versions of the MySQL ODBC driver (3.5, 5.2.7, 5.3.4).

Does anyone have any ideas of what might be causing the error? Really appreciate any help.

In Addition, I learn from Tableau certification course.
 
Thank you in advance.
image placeholder
Vivek Garg

asked  Sep 28, 2022

In Tableau I received the following error message:

The Google BigQuery service was unable to compile the query. Name Field1 is ambiguous inside Custom SQL Query at [62:33]

My BQ Query seems to work fine in BQ, but when copy paste in Tableau the above error shows. In order for me to track the error, I want to understand the error message.

What does [62:33] refer to? My query is only 47 lines of code, so I can't really seem to grasp the meaning of this notation...

In Addition, I learn from tableau online training.
 
Thank you in advance.
image placeholder
anonymous

asked  Apr 4, 2022

image placeholder
anonymous

asked  Nov 12, 2021

image placeholder
anonymous

asked  Oct 29, 2021

image placeholder
anonymous

asked  Jun 14, 2021

Python Code Error

669views
1answer
0votes
image placeholder
Harish Mehra

asked  Sep 7, 2022

Hi

I am using built in functions and libraries for this python code and I am trying to execute this code, but it is showing NameError.

 

import time
   
# slower (Without map())
start = time.clock() 
s = 'geeks'
U = []
for c in s:
    U.append(c.upper())
print (U)
elapsed = time.clock()
e1 = elapsed - start
print ("Time spent in function is: ", e1)
   
# Faster (Uses builtin function map())
s = 'geeks'
start = time.clock() 
U = map(str.upper, s) 
print (U)
elapsed = time.clock()
e2 = elapsed - start
print ("Time spent in builtin function is: ", e2)

 

Thanks.

What is data profiling in ETL?

1.9 Kviews
1answer
0votes
image placeholder
anonymous

asked  Aug 17, 2021

image placeholder
anonymous

asked  Jun 4, 2021