Forum Discussion
Refresh failed in server while connecting composite model
Hi Team,
i stuck with a issue. i have connected the data source from power BI dataset direct query mode. then i created the custom table using direct query table. second table connected from sharepoint (ie. Import mode). by refering all these different data source. i have created the dashboad in destop.
while doing refesh in destop , it is working fine. but when i push to workspace and do the refresh, it is not working. below screen shot for your ref.
Please advice me , if i have missed anything here. please provide the solution for this i am really stuck with this for one month.
Regards,
C.Mahavishnu
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
3 Replies
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