connecting two datamodels(sharepoint connection) gets error "data source ** is missing credentials"

[Anonymous]

The couple of days I worked on a connection with a datamodel. So I got this dimensional datamodel of my company and in powerbi with 'get data' I made a connection with the powerbi dataset. After that, with 'get data' I imported my data from the sharepoint into powerbi destkop and made a connection with the excel sheet with the powerbi dataset. In powerbi destkop it works fine to make visualisations with both datasets(company powerbi dataset and excel sheet imported and connected with sharepoint). Now when I publish it with powerbi service, than I got this weird error 'data source credentials error'. The weird thing is that I can make visualisations with the imported excel sheet from sharepoint but when I try to visualisate data from the company datasets it gives me an error. Does anyone know what to do? Tried literally anything

[Anonymous · Accepted solution]

I fixed the problem by going to the specific dashboard, after that I clicked on 'open lineage view' and there I could see my workbook with my imported excel. I clicked on that and there was an option underneath 'connection failed'. I clicked on 'go to settings' and there I could log in to my company account at the tab 'Data source credentials'. After that I fixed the problem.