Power Bi Measures Fail on Refresh

I am using the Asana connector for Power Bi and I have several custom measures. They work fine in the desktop but fail after the first refresh on Power Bi service

Please read this before posting

  • If you received an error from the API that you’re looking for help with, please include the error in your post and be descriptive of the requests you made that received the errors. To be clear, we need the error in the JSON response from the API, not the error your code raised.
  • Do not share any API credentials. Please check that the code you’re pasting into the post does not contain any real OAuth tokens or personal access tokens. If you have exposed credentials, you should revoke them immediately.

That’s really bizarre, what I would do to troubleshoot is make a hidden “scratch paper” page in the report when viewing it in the PBI Service under edit mode, then select the data that are inputs to the measure and the measure too. For my data I usually do this as a table. This is a good troubleshooting step.

Without knowing what errors you’re seeing or what failure you’re seeing it’s harder to be any more specific.