Improving Dax Query Performance
Hi all, I am looking to improve query performance. The report measures employee activity in a software, showing how many times someone "posted". I have a few lengthy measures in this report which are probably causing the visual on the right to be slow or even overflow. I have tried to clean it up a bit, but it is still pretty slow according to the Performance Analyzer. I would welcome any ideas here! I have attached the .pbix below. Thanks! - 170/243/8 refer to employee codes https://drive.google.com/file/d/1pQH4V1aSxYVWnQd-QMcmknrwu_ImbQ_5/view?usp=sharing
Power BI report server upgrade breaks Power BI Reports
We upgraded our Power BI Report Server from the October release to the new March 2018 release, now all power BI reports fail with the error "Query is too complex", even when the source is a tabular model. This failure happens on the new server and on the Power BI desktop, any help much appreciated
