Greetings

Thanks for the reply from lbendlin, please allow me to provide another insight.

Hi Jerz ,

Is this adventureworks dataset going to be restored to the database and then used in the database?

If so, then in my testing, before the dataset is restored to the database, if the dataset file is incorrectly changed to the .pbix file format your problem is reproduced.

If you are restoring to the MS SQL Server database, the file format of the dataset may be .bak.

AdventureWorks sample databases - SQL Server | Microsoft Learn
If you are restoring to the Analysis Services database, the dataset file format may be .abf.

Release AdventureWorks for Analysis Services · microsoft/sql-server-samples · GitHub

How to restore a SSAS Database - MSSQLTips.com

Best Regards,
Dengliang Li

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