Have you tried closing the secondary datasource? If you are indeed using fields from it, it will give you a warning telling you that closing it may break sheets in your workbook.
1 of 1 people found this helpful
Good morning Greg
I'd have to see the tebx workbook to be sure but is there any chance you had a workbook open when opened you new data source?
Just click on the second data source and it the dimensions and measures will show up
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Greg ,
1) Check for the Blended columns (red mark below )
2) Check for the Orange mark as below (Sum(saes) on RHS)
You must be having at-least one Orange field from the Secondary data-source.
You see orange only when you drag something from secondary DS so please check for the same
Please mark the answer accordingly if it really helps you