Most RecentMost ViewedMost LikesTo Star or not to Star, More about data modeling in Power BI using ADX Additional recommendations about best practices when using PBI to access data from ADX Data modeling and table lengths in Excel Hi, In an Excel solution, I bring in data from SQL connection to worksheet 1 (WS#1), thus the data set number of rows changes each time. A second worksheet (WS#2)runs calculation on WS#1. My problem starts when the WS#2 ends up with bunch of N/A or Errors dow at the button due to the table size not matching to the correspond number of rows pulled from WS#1. I suspect this must be a clear question for pro data modelers? I appreciate any help. Solved
