Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Icon for Resolver I rankResolver I
2 years ago

Unable to combine data - Power BI Service refresh error

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.)

 

2 Replies

  • 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's avatar
      Alicia_Anderson
      Icon for Resolver I rankResolver I

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