Sentiment analysis refresh workspace error

[SteelAPS]

Hi everyone this is the first time i reach out regarding a PBI Issue i have been facing, long story short. I am using AI azure sentiment analysis and sbarepoint data to do se timent analysis.

>I am able to refresh the data on my desktop and publish the report on a premium capacity workspace. But on the workspace the refresh fails

>I have tried all combinations of security roles and pbi privacy (public -private - org) and nothing

>I have tried changing the query and still issue persists.

>My tenant admin has tried changing settings but still nothing.

Again I can refresh it on my pbi desktop but on the published workspace i get the following:

• Data source error[Unable to combine data] Section1/CEP CSAT FO/Sorted Rows2 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface. Table: CEP CSAT FO.

Can sombody please help me out??

[SteelAPS]

Thanks so much for this, I built one sinlge query and it worked! 🙂

[v-yanjiang-msft · Accepted solution]

Hi @SteelAPS ,

Please refer to the solution in the similar thread: 

Solved: Unable to combine data - Please rebuild this data ... - Microsoft Power BI Community

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.