Refresh failed in server while connecting composite model

As the error message states you have created a mixed model (direct query to Power BI dataset plus calculated tables) which is not currently supported by service refreshes. If this is important to you please consider raising it at https://ideas.powerbi.com

Hi Anonymous ，

Thank you for providing a detailed screenshot of the error, I found two issues involved, the first one is about SSO login, it shows that you have not provided the required credentials, did you enable the following option when configuring the data source?

If yes, then SSO credentials are required.

And the second problem is obvious, as stated in the error message: a calculated table or a calculated column which references a Direct Query data source is not supported to refresh in the Power BI service. So you need to check and modify your data source

Best regards,

Community Support Team Selina zhu

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