7 Replies Latest reply on Mar 30, 2012 9:39 AM by Russell Christopher

Issue with Published Data Source

Jason Marotta Mar 29, 2012 2:03 PM

Set up a trial install of server and accessing that instance over the internet with Desktop Pro.

I've opened the required ports and I can connect to Tableau Server, and was able to publish (2) MS SQL Server data sources. These have been verified directly on the server to exist and work correctly there. MS SQL Server 2008R2 Express running on the same box.

The problem I'm having is when I try to "Connect to Data -> Tableau Server" in Tableau Desktop Pro, I can login just fine, but it says that there are "No Data Sources" available. Also, none of the demo data sources on the server are showing up either.

I'm sure I'm missing something obvious, but I've already burned a couple hours trying to figure this out.

Thanks in advance.

1. Re: Issue with Published Data Source

Russell Christopher Mar 29, 2012 2:09 PM (in response to Jason Marotta)

Heya, Jason!

My first guess is that users don't have the proper permissions to use the Data Sources you've published.

Login as an Admin and take a look at your data sources:

Choose the Permissions menu item, and see what you can see:

Use the "edit" hyperlink on the far right to see what "All Users" can do with the data source in question:

In this case, all users have permissions to view & leverage the data source.

You might also want to check the permissions that a particular user has against the data source with this dialog:

In the example above, user Test1 has the proper permissions to leverage the data source in question.

I'd suggest you eyeball this stuff first, and let us know if it all looks OK and you still have a problem.

Good luck!
Like Show 0 Likes(0)

Actions
2. Re: Issue with Published Data Source

Jason Marotta Mar 29, 2012 2:17 PM (in response to Russell Christopher)

Hey Russell-

Yes, the new data sources are configured and confirmed as above.
Did you see that I mentioned that the demo examples do not show up as well?

-Jason
Like Show 0 Likes(0)

Actions
3. Re: Issue with Published Data Source

Russell Christopher Mar 29, 2012 2:31 PM (in response to Jason Marotta)

Hey Jason -

We don't actually add any demo Data Sources to the server, only Data Connections that are a part of our sample workbooks...so those shouldn't show up.

Would you mind taking / posting a screenshot of what you see in the Data Sources list and what you see in Tableau Desktop?

I'm not a support guy and you may have to end up opening up a case, but let's see if we can't help you here first.
Like Show 0 Likes(0)

Actions
4. Re: Issue with Published Data Source

Jason Marotta Mar 30, 2012 8:36 AM (in response to Russell Christopher)

Hey Russell-

1st of all, thanks for the assist.

Here's what I see in Desktop:

Here's the Data Source detail:

Permissions for this source:

Permissions check:

-Jason
Like Show 0 Likes(0)

Actions
5. Re: Issue with Published Data Source

Russell Christopher Mar 30, 2012 9:01 AM (in response to Jason Marotta)

All that indeed looks fine. Very Odd.

Just curious - you are an admin, correct? (Not that one needs to be to make this work). I'd like to take Desktop out of the picture altogether.

If you login to Server (as an admin), and then run this:

http://localhost/manual/published/datasources.xml

...what do you get back? You should get a list of data sources. Mine looks like so:
Like Show 0 Likes(0)

Actions
6. Re: Issue with Published Data Source

Jason Marotta Mar 30, 2012 9:13 AM (in response to Russell Christopher)

Yes, logged in as admin, here's what I get:
Like Show 0 Likes(0)

Actions
7. Re: Issue with Published Data Source

Russell Christopher Mar 30, 2012 9:39 AM (in response to Jason Marotta)
OK - So the server doesn't think this data source is ready to be consumed for some reason - why? I'm not sure.

Two things:

Publish a new data source and try again - see if there is a change in behavior
From your screenshots, it appears you are using Sites (multi-tenancy). You are logging into the same site that the Data Source exists in when you request it, right? I get the same (bad) result as you if the data source lives in the Default site, and I request it from "Site2", for example.

...I think it probably is time to spin up a support ticket, in any case
Like Show 0 Likes(0)

Actions