March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
"Does the Translations Builder tool support POWER BI Desktop with SSAS tabular models as a data source?" I am getting error as attached
@AmiraBedhCan you recommend any resources or best practices for effectively integrating the Translations Builder with Power BI, particularly when dealing with reports that use a live connection to a Tabular Model as their data source? Although we have numerous reports drawing from a single Tabular Model, I have faced challenges in establishing a connection between Translations Builder and these reports, despite multiple attempts. Strangely enough, I am able to connect to other Power BI reports that use import mode without issue.
More about error details
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentOutOfRangeException: Index is out of range (should be bigger or equal to 0 and smaller than Count). (Parameter 'index')
Actual value was 0.
at Microsoft.AnalysisServices.ModelComponentCollection.get_Item(Int32 index)
at Microsoft.AnalysisServices.Tabular.DatabaseCollection.get_Item(Int32 index)
at TranslationsBuilder.Services.TranslationsManager.Connect(String ConnectString)
at TranslationsBuilder.FormMain.menuConnect_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, WM msg, IntPtr wparam, IntPtr lparam)
https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder
https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder-add-language
If you want to get your work done directly on SSAS tablar :
I am creating a POC using Translations Builder on Tabular Models. However, the guidance provided did not help, and I am still encountering the same errors.
Yes, the Translations Builder tool supports Power BI Desktop with SQL Server Analysis Services (SSAS) tabular models as a data source.
You already have an existing active connection to the SSAS tabular model which is conflicting with the new connection attempt.
Close Power BI Desktop completely and then reopen it.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |