topic Re: Connect Tableau to Power BI dataset in Developer

Connect Tableau to Power BI dataset

Anonymous — Tue, 05 May 2020 06:03:35 GMT

I am trying to connect Tableau desktop(2018.2 version) to Power BI datasets. But i am getting an error saying:

I am a premiuim user and am a memer of the workspace where we have published the dataset. I am using the connection string to connect to the dataset from tableau.

Here is the error I am getting:

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

Thanks

Re: Connect Tableau to Power BI dataset

Anonymous — Tue, 05 May 2020 22:54:48 GMT

Hi ,

I have tried the steps in the below URL:

https://senturus.com/blog/how-to-use-power-bi-datasets-in-tableau/

i have replaced the workspace connection with my org details but i get the same error as earlier.

Any help appreciated.

Re: Connect Tableau to Power BI dataset

V-lianl-msft — Wed, 06 May 2020 23:33:07 GMT

Hi @Anonymous ,

According to your description, your organization has premium capacity, which is one of the prerequisites, and you need to have pro license.Check if you have pro license and install the latest Analysis Services client libraries.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Connect Tableau to Power BI dataset

Anonymous — Thu, 07 May 2020 22:02:20 GMT

hi Liang

Thanks for getting back to me.

our company has the premium, i have a pro user license and i have also installed the latest drivers of analysis services (from the Tableau site).

I have used the same workspace connection string with a excel workbook and i was able to see the datasets.

Re: Connect Tableau to Power BI dataset

V-lianl-msft — Fri, 08 May 2020 05:30:50 GMT

Hi @Anonymous ,

Will this be caused by azure firewall?Check if azure firewall is blocking this connection.

If the problem persists, you can create a support ticket to help you.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Connect Tableau to Power BI dataset

LindaH — Wed, 02 Dec 2020 10:32:36 GMT

Hi Liang,

Can you provide more information on how to check if a firewall is blocking this connection please?

Thanks,

Linda

Re: Connect Tableau to Power BI dataset

LindaH — Wed, 02 Dec 2020 10:40:32 GMT

Hi All,

When the Tableau connection says if you are using Azure AD/2FA then leave the username and password blank this does not prompt for 2FA. I typed space for username and space for password I got prompted for 2FA.

Hope this helps for others.

Regards,

Linda

Re: Connect Tableau to Power BI dataset

JimJim — Fri, 10 Nov 2023 15:41:32 GMT

I was experiencing this issue and the drivers suggested by Tableau weren't working. In the end I installed the latest version of SSMS which included the correct drivers and fixed the issue. Installing SSMS to get this working definitely seemed like overkill but it did the job