Problem Exporting report in PDF
Hello, I am having problem exporting a report in PDF. When I export the same report in Excel it Prints in landscape in 2 pages but when I export the same report in PDF it scatters. However, when I export the report in Excel and convert in PDF it prints well but I want the viewers to have the same view as in excel but in PDF view. What do I need to do in the formatting? THank You
Error: A query may contain up to a total of 100 extension measures and columns
Hi everybody, today I encountered the following error while trying to perform a sum over different measures: "The query contains too many (127) extension measures or columns. A query may contain up to a total of 100 extension measures and columns. Please reduce the number of extension measures or columns in this query." This happens when I try to sum 8 measures to obtain one (simply tot = m1 + m2 + ... + m8). Each of the measure is calculated based on other measures and aggregations, but some of these correlated measure are not visible to me (as per client disposal I can work only on the front end of the PowerBi Dashboard and I can not create columns, only measures) so I can not try to optimize the data model . The question is, is there a way to perform the summation? Any suggestion will be usefull. Thank you in advance, Silvano