PBIRS Odata - cannot pull data with url from shared datasets
Hi, I've been using PBIRS. i want to use shared datasets in my powerbi reports with odata. I created shared datasource and shared dataset (using shared datasource). When run the url above, i got shared datasets list on my PBIRS. this link downloads with json file format and i can see my shared datasets. url : https://myservername/reports/api/v2.0/datasets when i run this url to see data on shared datasource, it throws error; url : http:s//myservername/reports/api/v2.0/datasets(fb3ceb83-3b05-4512-b543-2b83bd30da6e)/data error description : {"error":{"code":"220","message":"The data set could not be processed.","details":[{"code":"222","message":"There was a problem getting data from the Report Server Web Service: The operation you are attempting on item '/MyFolder/Dataset1' is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item '/MyFolder/Dataset1' is not allowed for this item type."}]}} so, i can not work with this url on odata on powerbi desktop. what should i do?
Issue while using a shared dataset via ODATA in Power BI Report Server/Desktop
So we created a shared data source in Report Server based on AdventureworksDW2016 (the dimCustomer table). We want to use it as a data source for Power BI. So I tried first to find out the GUID of the data source (any easy way how to do that? I connected to the "catalogitems" and took it from there, so using an OData source with this url: localhost/reports/api/v2.0). I find the GUID there and used it to create this URL: localhost/reports/api/v2.0/datasets(2b8f51be-3839-48a3-8dbd-9211c3af2c3b)/data (this is from what I can read from the instructions https://powerbi.microsoft.com/en-us/documentation/reportserver-access-dataset-odata/). However the result I get is just a single column with a lot of GUIDs. I think these instructions can be improved as well as the whole process. However: How can I get this work?