Unable to Select Files With Capitalized Extensions on OneDrive and Google Drive

KNOWLEDGE BASE

Unable to Select Files With Capitalized Extensions on OneDrive and Google Drive

Published: 02 Jul 2019
Last Modified Date: 30 Nov 2019

Issue

After connecting to OneDrive or Google Drive in Tableau Desktop, files with a capitalized extension are grayed out and cannot be selected.

Environment

Tableau Desktop
Google Drive
OneDrive
Box
Dropbox

Resolution

Option 1

Use the equivalent native connector for the file in Tableau Desktop. For example, to connect to a Microsoft Excel file use the Microsoft Excel connector.

Option 2

Edit the name of the file and change its extension to lowercase. If the extension cannot be changed, in a File Explorer window click the 'View' tab and ensure the 'File name extensions' option is checked.