Skip to main content

Power BI

New

Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

Vote (50) Share
Bhushan's profile image

Bhushan on 21 May 2018 12:13:47

Connecting Power BI Report Server Shared Data Source from Power Bi DeskTop. This Feature is available in Power BI Service. We can connect Power Bi Service published data sources from Power BI Desktop. However this is not available in On-Premise.

Comments (6)
Bhushan's profile image Profile Picture

6fe834de 0568-4dd8-b8de-892e012f01fb on 05 Jul 2020 23:57:00

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

Would be great to have shared data sets to reduce duplication of data and align it with data governance processes. Would also be great to have shared data sets with certified quality and some associated meta data attributes such as data owner, information sensitivity, etc.

Another thing would be interesting is an option to publish these shared models to SSAS

Bhushan's profile image Profile Picture

7de092fd c230-46fe-8055-bab7f47faa87 on 05 Jul 2020 23:53:11

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

Agree its hard work to manage lots of PBI Reports even if I have a small number of data sources. Surprised this is not yet a feature. This and easy deployment stop the on premise being an enterprise product.

Bhushan's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:36:42

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

This feature is very important for security. If the IT can manage the sources by publishing it on PBIRS then the user don't need to connect directly to the datasource but just through the PBIRS. In a big society it is strictly forbiden to connect a desktop to a datasource. Futher more, other product like Tableau implement this feature like the power BI services. So i don't understand why this feature is not already done.

Bhushan's profile image Profile Picture

5d6358a8 5925-4615-8c7c-35d4a3667ba3 on 05 Jul 2020 23:36:08

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

This feature is very critical for every user who is migrating their reports from SSRS to power bi report server

Bhushan's profile image Profile Picture

f7f85ddb 5eb0-4f9a-ad53-381e9812d5f3 on 05 Jul 2020 23:30:37

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

It would be great have SSRS shared data sources accessible for PowerBI report (on-premises) same as Paginated reports, it reduces lot of manual activity to change data-sources in each report, specially when there are 50+ PowerBI reports and all are connected to central database WH server.

Bhushan's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:24:24

RE: Connecting Power Bi report Server Data Source (Shared Data Source) from Power BI Desktop to develop the report.

This would be a great feature as it would allow you to refresh the data in one place and then have multiple reports connecting to that data for the visualizations. This is like connecting to SSAS but the development using Power BI to build the data source is much easier.