So we want to do this, but it’s not supported. So we must pursue a alternative solution. Optimally this would something that could be run from SQL Server directly with minimal external code possible.

I would like a powershell script that allows me to run a large MDX statement against a cube in a Fabric Workspace. I would like to be able to call that script directly from a T-SQL proc in SQL Server 2022 and would support the return of a result set consistent with the same cube running the same MDX statement on a traditional Analysis Service instance.(Same column names, formatting, etc..)

It’s critical that this script supports MDX statements larger than 8000 characters and can return (and SQL Server can use) large result sets.

The initial research I’ve done indicates that this is a non-trivial challenge (see above link for the first problem), I’m not the first person to ask for this, but I haven’t seen anything that does this directly. It would be nice to have a community contributed answer that other people could use, if there isn’t one or if the community can’t do this I will post my solution and allows other to improve upon it.