Connect Power Bi to Data Set

[ringovski]

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.

[d_gosbell]

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:

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

[ringovski]

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

[d_gosbell · Accepted solution]

---

@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