Forum Discussion
Unable to Deploy Large Tabular Model to Power BI Embedded (A2) Workspace
Will try this. I wonder if we could get marco @ SQLBI to add XMLA deployment support in TE3. That would be the cleanest given that TE2 had the functionality albeit without the AAD/MFA authentication. I suspect it's a big lift but SLQBI is super-human in their abilities!
Hi charleshale ,
Thanks a lot for the suggestion lbendlin really appreciate it. Yes, I did try both SSMS and PowerShell
- SSMS: Couldn’t get past the authentication part due to lack of modern AAD/MFA support.
- PowerShell: Faced similar issues. Invoke-ASCmd fails to fetch token, even with the right modules and credentials.
What finally worked for me was using Tabular Editor 3 CLI, but only after wrapping the model in a .te3proj structure and making sure Large Dataset Storage Format was enabled in the workspace. Still feels like we need a more consistent and officially supported path for deploying large models to Power BI Embedded especially with modern auth.
Regards,
Akhil
Will try this. I wonder if we could get marco @ SQLBI to add XMLA deployment support in TE3. That would be the cleanest given that TE2 had the functionality albeit without the AAD/MFA authentication. I suspect it's a big lift but SLQBI is super-human in their abilities!