Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Export Power Pivot Data Model

  • 1.  Export Power Pivot Data Model

    Bronze Contributor
    Posted 24 days ago
    Hi,

    I have a data visualization solution that's built in excel and I am wanting to migrate the calculated columns, measures and KPIs to a SSAS tabular model connected to the same sql server query. Is there a way for me to export them from the excel power pivot data model and import them into my tabular model?

    ------------------------------
    Allan Blain
    Project Manager
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Export Power Pivot Data Model

    Top Contributor
    Posted 23 days ago
    To import a workbook, from Power BI Desktop select File -> Import -> Excel Workbook Contents. A window appears, letting you select the workbook to import. There is currently no limitation on the size or number of objects in the workbook, but larger workbooks take longer for Power BI Desktop to analyze and import


    https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks



    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Export Power Pivot Data Model

    Bronze Contributor
    Posted 23 days ago
    Thanks Farhan,

    But how do I this in a Visual Studio SSAS solution?

    ------------------------------
    Allan Blain
    Project Manager
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: Export Power Pivot Data Model

    Top Contributor
    Posted 23 days ago
    Try this.

    https://docs.microsoft.com/en-us/analysis-services/tabular-models/import-from-power-pivot-ssas-tabular

    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Export Power Pivot Data Model

    Bronze Contributor
    Posted 23 days ago
    Thank you very much!

    This is exactly what I was looking for!

    ------------------------------
    Allan Blain
    Project Manager
    ------------------------------

    Conference-PBI_200x200