Data refresh in the desktop but not in the power bi service

[Nepal101]

Hello Everyone, 
I have this error below where the refresh work in the desktop but when I schedule the report in power bi service it is showing below error can anyone help me out?

Thank you 



error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[Unable to combine data] Section1/FMSquery/Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}} Table: FMSquery.

[lbendlin]

As it says in the message 

FMSquery/Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination

repartition your queries to avoid the formula firewall.

Do you need to combine your sources this way or can you let the data model do the work for you?