I had a PowerPivot workbook uploaded to onedrive for business and then connected to the Power BI service. The workbook has connections to SQL server on-premise an to other Excel workbooks on onedrive for business. The sheduled refresh works just fine.
Now in the PowerPivot workbook - that already had Power queries on singel sources - I added a merge query between data from SQL server on premise and data from an Excel workbook on onedrive for business. This merge query executes perfectly in local Excel but whan connecting the update PowerPivot workbook to the Power BI service, I get an error (with status code 200) when I try to give my credentials for a sheduled refresh in the Power BI service.
I also noticed that for the sheduled refresh of the 'older' PowerPivot workbook I had to give credentials 3 times (once for SQL Server on premise, and once for each Excel workbook source on onedrive for business. For the 'new' PowerPivot workbook, I have to provide credentials 4 times (???). for 3 of them (1 for SQL Server OLEDB and 2 for onedrive for business workbooks WEB) my credentials are accepted, for the 4th one i'm asked to give credentials for a workbook on onedrive for business but here I get an error with status code 200.
Apart from the status code 200 I get no further information about the error whatsoever. Can someone help me please ?
