Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @rkapukaya ,
1. Is this just a clerical error?
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
2. Please check if this post is helpful:
I removed the database from the AG and still not working. I did find something interesting that led me to a solution. While in reporting services connection manager I clicked the URL for the Web Service. It prompted me for credentials. I was able to get to the web service after entering valid credentials. On a hunch that this could be the issue. I added an URL that is configured for all assigned IP addresses. The URL that is created is server name/reportserver. When I click on this new URL it get directly to the web service without having to enter credentials. Now preview works and I can load a dataset in Mobile Report Publisher. All is working now.
I originally configured the URL to be the AG listener for the AlwaysOn AG. This was causing a prompt for credentials. Now that I have added the new URL everything is working. Although probably not in the case of a fail-over.
I guess now my question would be is there a setting that would prevent the credentials being prompted on the AG listener URL.
Thanks
Reference: Data Preview Error in SSRS 2016 (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Icey
1) sorry, i copied wrong. It starts with https://....
2) When i clicked report server url nothing shows up.
After that, i tried another steps;
* Open new PBIRS desktop and exract table from database
* I changed code on advance editor like below and error came up;
My odata feed code;
let
Source = OData.Feed("https://MyReportServer/Reports/api/v2.0/datasets(DataSetId)/data",null, [MoreColumns=true])
in
Source
Error description;
DataSource.Error: OData: Request failed: The remote server returned an error: (422) Unprocessable Entity. (The data set could not be processed.)
Details:
DataSourceKind=OData
DataSourcePath=https://MyReportServer/Reports/api/v2.0/datasets(DataSetId)/data
Url=https://MyReportServer/Reports/api/v2.0/datasets(DataSetId)/data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |