Forum Discussion
Data gateway support for paginated reports
Power BI TeamHi Michal,
I don't think we have tested this scenario of using SQL Managed Instance through Gateway. Why are you trying to use GW here rather than connecting to it directly. Asking since GW is primarily a means to enable on-prem data sources to be used in cloud scenarios.
Also, if you have created a Power BI Dataset using this data source (you likely have this as part of uploading the PBIX report you created), you can have your Paginated Report connect to this Power BI Dataset through the XMLA endpoint. https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/. In Report Builder, use "Microsoft SQL Server Analysis Services" as the data source. Thanks.
hi rpatkar I need Data GW as our MI endpoint isn't exposed outside a dedicated vnet and in that case we can't trat it as public accessible source.