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.
i am using powerbi report server. I want to create a datasource and use this datasource on my multiple powerbi reports. Normally, i can create one datasource (.pbix) on cloud version and when i publish it, i can use this datasource for multiple reports. Based on my research, PBIRS does not provide this feature. I use direct query option on my reports and want to create this datasource without SSAS option.
So, i decided to try "Odata feed" option. First, i created shared datasource (MsSqlServer) and datasource connects succesfully (with db user). Second, i created dataset using a small table ( 5 columns, 5 rows) using shared datasource.
The problem ; when i manage to dataset --> Data Preview --> Load data error shows up;
"The data set could not be processed.
There was a problem getting data from the Report Server Web Service."
Because of this error i can not use api url for Odata feed on my pbix file to get data from shared dataset. How can i manage solve problem?
Hi @rkapukaya ,
Have you ever try to connect to other dataset in your report server? Did it only happen on specified dataset? Based on my research, it could be the issue with the option below:
Please try to inactivate it and try again.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
hi @v-deddai1-msft ,
I unchecked, closed-opened pbix and tried again but it still throws same error.
I have 3 datasets, one of them connects to sqlserver and others connect to oracle db. It happens for all datasets.
Besides, when i paste url to browser it throws error too. Also, when click "load data" via browser after create and save shared dataset i can not see data & error : There was a problem getting data from the Report Server Web Service."
Best Regards,
Ramazan
Hi @rkapukaya ,
I can't reproduce your issue. Would you please open the trace in desktop and gather the detailed error message for us?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @v-deddai1-msft ,
As you mentioned, i activated diagnostic and followed this steps;
get data -> odata feed -> pasting url and ok.
here is the log file link, you can download from here;
By the way, when i want to get dataset list with odata feed it work successfully and i can see data,
here is the url that i can get dataset list;
https://myserver/Reports/api/v2.0/datasets
Hi @rkapukaya ,
Is your m query similiar to :
let
Source = OData.Feed("https://sample.com/Reports/api/v2.0/datasets(DatasetID)/data",null, [MoreColumns=true]),
#"Expanded More Columns" = Table.ExpandRecordColumn(Source, "More Columns", {"ID", "TITLE", "PRIORITY", "IMPACT", "MODIFIED", "CREATED"},
in
#"Expanded More Columns"
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello, try to change source type to Web. PBIRS returns data in json format.
Hi @v-deddai1-msft ,
Yes i tried like this on powerbi desktop (report server edition).
Beside, I work on my PBIRS server.
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 |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
5 | |
3 |