Forum Discussion
Connect 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
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"
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
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
