Unable to combine data - Power BI Service refresh error

[Alicia_Anderson]

The report runs fine in Power BI Desktop but when I publish it to the service it errors.  I feel I have tried about everything but nothing works.    

1) I made sure all my data sources privacy settings were set the same: Organizational.

2) I have my Privacy settings in Power BI Desktop set to "Ignore the Privacy Levels..."

3) I attempted to combine my function into the main query so that it is in one query.

Here is my code.  What am I doing wrong? (Didn't like the code so pasted a screenshot.)

[GilbertQ]

Hi @Alicia_Anderson 

What you could do is instead of having to "let' functions rather just add the previous steps all in your single table and then reference it in the later steps?

[Alicia_Anderson]

I appreciate the suggestion but I am having trouble figuring out how to make that work.  Could you mock up my screenshot?