Connect tabular model to excel via Power BI semantic model

• Bhagat

  SSC-Addicted

  Points: 408

  More actions

  May 19, 2025 at 3:48 pm

  #4593457

  I have a tabular cube, with myself included in one of the roles.

  I can connect to this tabular model via Excel successfully, and would now like to connect to a Power BI semantic model rather instead.

  However I get the attached error.

  I suspect there additional security needed to be defined, but unsure where.

  I have direct access permissions on the data model within the Power BI workspace.

  Any suggestions welcome? Thank you.

  Attachments:

  You must be logged in to view attached files.

• Martin Schoombee

  SSCoach

  Points: 19135

  More actions

  May 20, 2025 at 3:51 pm

  #4594121

  It's possible that you're just not using the correct url for the connection, because the connection string for data models in Power BI look a little different.

  Use the "Analyze in Excel" feature from the context menus of the data model in the Power BI workspace. Once you have the open Excel document open, you'll be able to look at the properties of the connection.

• Bhagat

  SSC-Addicted

  Points: 408

  More actions

  May 30, 2025 at 12:33 pm

  #4599914

  I get the same error when using Analyse in Excel from the Power BI report.

  On another forum, it was suggested this feature requires Premium or Fabric capacity where my organisation has Pro.