Power BI MYOB Integration

[tidjy]

Power BI content pack is including the MYOB opening balance and current balance when calculating current assets, current liabilities and working capital. Has anyone else had this problem? It is calculating wrong and often double what they should be, I suspect Cash at Bank is the same as it also looks really wrong. Does anyone know how to fix this?

[v-yuezhe-msft]

@tidjy,

Please use Power BI Desktop to connect to MYOB following the guide in the blog below, and calculate required data by creating your own measures/columns.

http://help.myob.com/wiki/display/ar/Power+BI+Desktop#expand-4Openthereporttemplate

Regards,
Lydia

[tidjy]

Thanks, I've done that. Just doesn't fix the cloud solution. Hopefully MYOB/Power BI content pack providors fix it soon. 

[v-yuezhe-msft]

@tidjy,

You can upload PBIX file to Power BI Service to work around this issue.

Regards,
Lydia