We have tableau reports but in backend we are changing to Fabric. where we will be getting SQL endpoint of Fabric Lakehouse data and will be connecting tableau using 'Azure SQL' connector driver.
What are the Consequences or challenges we can face with tableau comparing with SQL server DB connecting tableau with one table/view.
Finally I have found the solution.
As per docs port 443 should be opened for selected endpoints (1): https://learn.microsoft.com/en-us/fabric/security/fabric-allow-list-urls#fabric-platform-endpoints
but as confirmed with Microsoft it’s not enough and all IPs with Power BI tag should be whitelisted (thousands of them)(sick!)(2): https://www.microsoft.com/en-us/download/details.aspx?id=56519
If you do (1) only then connection can't be made but of course if entire 443 is open you an make the connection. The final solution should whitelist IPs from (2)
Then you will need to have oAuth2 client installed in your Tableau site (as only oAuth2 authentication is supported).
