Multiple Power BI workspaces

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure

https://docs.microsoft.com/azure

Creative Commons Attribution 4.0 International

10.28k stars 21.45k forks source link

Multiple Power BI workspaces #67697

Closed BE-Digital-Solutions closed 3 years ago

BE-Digital-Solutions commented 3 years ago

According to this documentation page, it's currently possible to link only a single Power BI workspace to an Azure Synapse Workspace.

Is it planned on the Microsoft roadmap to remove this limitation? Could you provide an estimated timeline?
Is there an alternative, e.g. by connecting to the data sources using a Power BI Data Gateway deployed in a vNet with private endpoints to the corresponding PaaS resources (to protect against data exfiltration)?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

ID: 0cd443b5-c0b0-0506-09ea-e8776b924819
Version Independent ID: 466a89e7-0271-35df-1407-653484659643
Content: FAQ - Azure Synapse Analytics
Content Source: articles/synapse-analytics/overview-faq.md
Service: synapse-analytics
Sub-service: overview
GitHub Login: @saveenr
Microsoft Alias: saveenr

MonikaReddy-MSFT commented 3 years ago

@BE-Digital-Solutions-Bart - Thank you for your question. Can you please share with us the URL of the document that you are having issues with? Please note that we scope issues on this repo to feedback related to the docs. If you have a product question, please post it on Microsoft QnA or Stack Overflow. Thank you for your understanding.

BE-Digital-Solutions commented 3 years ago

https://docs.microsoft.com/en-us/azure/synapse-analytics/overview-faq#q-can-i-link-more-than-one-power-bi-workspace-to-a-single-azure-synapse-workspace This FAQ page just contains one line that mentions the current limitation.

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources This documentation page shows that it's also possible to connect to many data sources using a Data Gateway, incl. Azure Data Lake Storage Gen2 & Azure SQL Data Warehouse. The SQL Serverless Pool is not mentioned, but I'm not sure whether there is currently a way to create a private endpoint to it in your own vNet, is there?

ArnoMicrosoft commented 3 years ago

@BE-Digital-Solutions-Bart

We have a plan to remove the limitation (1 per workspace). On the Power BI, the document, should be updated. It's not current.

Thank you, Arnaud

MonikaReddy-MSFT commented 3 years ago

@ArnoMicrosoft - Thanks for providing your insights. @BE-Digital-Solutions-Bart - Thanks again for bringing this to our attention. We have updated the Doc and it will be live once its merged. We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion and we will reopen the issue.