Skip to main content
Microsoft Idea

Power BI

Needs Votes

Use Power BI Service as a 'Linked Server' (to use it in SSRS / KPI Snapshots / ... )

Vote (3) Share
Sander A.'s profile image

Sander A. on 19 Dec 2018 01:42:03

It would be of added value if the 'Power BI Service' can be added as a 'Linked Server' in SQL Server.
This would enable SSRS report builders to use it as a datasource and to build SSRS reports on it (= using DAX in OPENQUERY modus in SQL Statements). Additionally, also snapshots of measures can be saved in SQL Server.

Background info: I have already build countless of reports in SSRS using Analysis Services as a source (both using the SSAS connection as well as using OpenQuery). One of the advantage is that you can join the result of multiple linked SSAS servers in one SSRS report (... which is not possible without using 'Linked Servers').