Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
"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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
153 | |
101 | |
82 | |
63 | |
52 |