recreating matrix as measure with calculated column
HI there, I'm in quiet a pickle, I appreciate any help I'm using a powerBI shared Dataset and I don't have the power query options; I was wondering if it's possible to recreate a matrix using a measure since measures are the only thing I can use in this case; my data is as follow: it rapresents people from comapnies enrolled in training courses and I'd like to know if a company is a recurring customer or not. I would like to create a matrix (counting the number of participant by year) with a calculated column, is it possible to do it only using measures? the calculated column would be a field with Yes or NO based if a company is a returning customer: the logic of the returning would be: - if a company has at least 1 person enrolled in 2022 and none in previous years = YES - if a company has at least 1 person enrolled in any other year and not in 2022 = NO - if a company has at least 1 person enrolled in previous years and in 2022 = YES I appreciate any help, thanks
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.
