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?

6 REPLIES 6
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

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
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.