Forum Discussion
Connect Power Bi to Data Set
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
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