Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
VVinayKumar
New Member

Translations Builder

"Does the Translations Builder tool support POWER BI Desktop with SSAS tabular models as a data source?" I am getting error as attached Screenshot 2024-08-05 193058.png

4 REPLIES 4
VVinayKumar
New Member

@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 :

https://learn.microsoft.com/en-us/analysis-services/tabular-models/translations-in-tabular-models-an... 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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.

AmiraBedh
Community Champion
Community Champion

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. 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.