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?
Use shared datasets from Report Server with Power BI Desktop RS
Is there a way to use shared datasets from Report Server on Power BI Desktop RS ? If the only way is OData feed, is it possible to use datasets with more than 400 000 rows and in reasonable times ? For now, I need to reduce the number of rows in my dataset so it does not fail when importing on Power BI Desktop RS and it can takes more than 30 minutes... Thanks for your time and help !
Shared data sets in PBRS
Hi, We are looking to implement Power BI Report Server for initially about 50 reports. All data will be sourced from an Oracle DW. Our initial idea was to build an "analytical data model" inside Power BI Report Server, a shared dataset that all 50 reports could use in order to simplify things and minimize the number of queries made to Oracle. However, according to the below forum post, sharing datasets across PBIX files is not possible? https://community.powerbi.com/t5/Report-Server/Sharing-data-sets-in-Power-BI-Report-server/m-p/496212#M7352 Have I misunderstood something? This seems like a necessary functionality for organizations with hundereds/ thousands of reports in Power BI Report Server.