I have a SharePoint (Online) List which has many fields(columns), and when I try to import as a DataSource in Tableau Desktop, I am getting the below error because it exceeds the lookup column threshold.
"The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator"
Hence created a SharePoint List View with only required fields(columns) and also made it default view only. But still, this new List View is not available to use it for modeling in DataSource Page of Tableau Desktop. Only the actual SharePoint List is available to use, but not the newly created List View.
I did check below articles, but no luck....
Could someone help me out here?
At last I got it fixed!
The solution to this problem is to simply hide the unnecessary columns so that only the required columns are part of Extract.
It's the same concept as traditional Database data sources.