I have the latest version of analyse in excel installed. I have build permissions on all datasets in the workspace. I can use "analyse in excel" from the power platform to create a spreadsheet that accesses that dataset. However, if I just open a new spreadsheet and try to insert a pivottable and use the From PowerBI option, only 2 datasets appear in the Power BI Datasets menu on the right side of the spreadsheet. There should be at least 30 of them.
I've checked my file->options-> trust center and they are all set according to documentation.
why can I see just 2 of the datasets and not all of them?