User Profile
fengwufangzhu
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Gateway Refresh Error SharePoint: Request failed
Hi Folks, We have a report runs well on desktop and primary gateway and now we would like to set up a backup gateway connection. The refresh cannot get through after running for about 1 hour and the same error always appear:SharePoint: Request failed We tried many time, such as switching between gateways, the old one always work, the new one always fail. Also tried clear permission, re-login, publish to a different workspace... Our PBI gateway admin could not figure out why. I suspect this could be some version or compatibility issue?SUM of ALLEXCEPT is Wrong however Row Level Correct
Dear folks, I am trying to simulate customer occupancy rate in building by level. The first part is simple by count distinct ID column. However there is complication that certain customer have committed space and we would like to know utlisation based on both actual and allocated usage. This requires me to get an aggregated number (LOD in tableau terms) using ALLEXCEPT and then compare with the commitment number in another table (linked with customer+level relationship). The idea is to see if customer utilisation is lower than allocated, then the higher number will apply. The calcuation works well on row (customer/level) level however the sum is wrong (should be 5+8+3=16 not 13). I need this total to be correctly displayed on card and react to the slicers. Somehow I am stuck for a few hours while exploring many ways. The raw data is connected to database. I have attached an indicative PBIX file. Appreciate help. https://www.dropbox.com/s/7e4845tuk29mdd3/test.pbix?dl=0
