topic Re: Connect Power Bi to Data Set in Report Server

Connect Power Bi to Data Set

ringovski — Thu, 10 Aug 2023 00:48:29 GMT

Hi All,

I have made a SSAS multidimesional data set in Report Builder and published it to the on premise reports server and I am wondering if it is possible to connect Power Bi to it and if so how?

Thanks for any assistance.

Re: Connect Power Bi to Data Set

d_gosbell — Thu, 10 Aug 2023 01:53:50 GMT

If you have kerberos authentication configured it would be much simpler to just live connect your Power BI report direct to SSAS

But you can also connect to a shared dataset in Report Server using the odata feed for that data set with the following steps:

In Power BI desktop Choose to add data from an OData feed
use a url like the following https://<server>/reports/api/v2.0/DataSets(path='<path-to-dataset>')/Data
In the advanced options choose "Include open type columns"

Re: Connect Power Bi to Data Set

ringovski — Fri, 11 Aug 2023 02:28:50 GMT

Thanks the reply.

I haven't been able to get it to work. My report server url datasets are https://bi.xxx.yyy.aaa.bbb/reportsbi/browse/datasets looking at various web sites it the key is getting the token id or key for the data set.

https://learn.microsoft.com/en-us/power-bi/report-server/access-dataset-odata

This sample is very close to your example but I need the string in the brackets, how do I generate that?

Cheers

Re: Connect Power Bi to Data Set

d_gosbell — Fri, 11 Aug 2023 05:05:24 GMT

ringovski wrote:

This sample is very close to your example but I need the string in the brackets, how do I generate that?

There are 2 options. If you want to use the id of the dataset you can call the following endpoint to get a list of all the datasets and you can use the id property for the dataset you want.

https://<server>/reports/api/v2.0/DataSets

then you just call https://<server>/reports/api/v2.0/DataSets( <your-dataset-id> )/Data

Or it looks like you have your datasets in a folder called "datasets" so you could use the path='' syntax in the brackets and use folder/dataset format:

https://<server>/reports/api/v2.0/DataSets(path='/datasets/<dataset-name>')/Data