Connect Tableau to Power BI dataset

[Anonymous]

Hi 

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

[JimJim]

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

[LindaH]

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

[Anonymous]

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.

[V-lianl-msft]

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.

[Anonymous]

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.

[V-lianl-msft]

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.

[LindaH]

Hi Liang,

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

Thanks,

Linda