FetchDatasets was unsuccessful

Hi, rsaccone 

Here are things to keep in mind for connecting to Power BI datasets in Excel:

• Analyzing Power BI data in Excel is supported for Microsoft Excel 2010 SP1 and later.
• Your dataset in Power BI must have pre-defined measures. Excel PivotTables don't support drag-and-drop aggregation of numeric fields.
• Analyzing Power BI data in Excel requires that the dataset be in a Power BI Premium workspace or that you have a Power BI Pro or Premium Per User (PPU) license.
• You have to have permission for the underlying dataset if you want to connect to Power BI datasets in Excel. You could have this permission in a few ways. You could have the Member role in the workspace containing the dataset, or have Build permission for a dataset in a workspace or in an app that contains the dataset.
• You can only analyze Power BI data in Excel on computers running Microsoft Windows.

You can also refer to the following document, which I hope will help you.

https://docs.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel#prerequisites 

https://docs.microsoft.com/power-bi/collaborate-share/service-analyze-in-excel#other-ways-to-access-power-bi-datasets-from-excel 

https://docs.microsoft.com/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.