Forum Discussion
Helper IIConnect Power Bi to Data Set
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.
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
3 Replies
- d_gosbell
Super User
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"
ringovskiThanks 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
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