cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rkapukaya
Helper I
Helper I

PowerBI Report Server shared dataset can not display data on browser

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?

7 REPLIES 7
v-deddai1-msft
Community Support
Community Support

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:

Untitled picture.png

 

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

 

 

 

 

 

 

 

 

 

v-deddai1-msft
Community Support
Community Support

Hi @rkapukaya ,

 

I can't reproduce your issue. Would you please open the trace in desktop and gather the detailed error message for us?

 

Untitled picture.png

 

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;

https://we.tl/t-0zN4WvxMio

 

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

v-deddai1-msft
Community Support
Community Support

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

 

 

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!