Thank You for posting your query onto the Forum.
@BrianJ - Thank You for providing me the opportunity to answer this question.
Well, although the Power BI is not able to refresh in the Service. I strongly feel that the real problem lies into the data itself. I saw the post where you’ve mentioned that your data contains the “10 Calculated Columns”. (10 calculated columns in the salesInvoiceLines to be able to have the invoiced items for the past 10 weeks and that too for looking at some invoiced quantity between 2 dates).
Just few minutes before @BrianJ looped me into this post. I was watching one of the video from Guy In A Cube where Adam Saxton was talking about this similar of scenario about the “Slow Refresh”. Just to get going I’m providing a link of that video below. Also is it possible for you to convert those 10 columns into the measures because it’s just simply increasing the breadth of the data and therefore every time you write a formula it will have to do tremendous iterations through the entire table.
Also came across through the article from the Microsoft based on this topic. I’m providing a screenshot below of the main points as well as link of the entire article. (2nd Point is very important in your case)
Lastly, if you’re having and using a DAX Studio in your machine. Can you please check which column is actually taking the huge amount of time? And accordingly we can take further course of action since I also not a PRO using at DAX Studio and then accordingly we can loop in the experts, if required at all.
Hoping you find this useful and atleast we can start onto something using this links of articles and videos.
Thanks and Warm Regards,