Skip to main content

    Power BI

    Needs Votes

    Connecting to a Data model in PBI Desktop file from Excel

    Vote (4) Share
    's profile image

    on 11 Sep 2016 22:28:22

    Connecting to a Data model in PBI Desktop file from Excel – I know this is not in the preview of the PQ team – but I would be grateful if you can nudge the Excel team in this direction – Just being able to connect to the Data model in the PBI online of absolutely no use.

    Comments (1)
    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:29:54

    RE: Connecting to a Data model in PBI Desktop file from Excel

    https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/

    This only allows you to connect to the Data model in the Cloud (powerbi.com)

    We would like to connect to the Data model of the locally stored Power Bi DEKTOP file (.pbix)
    This is currently possible but requires a hack
    1. Open the Power BI Desktop file (this has to be kept open)
    2. Find out the localhost port no using either DAX Studio or via Power Shell
    3. Open ExcelTab Data  From Other Sources From Analysis Services  Type localhost:XXXX – where XXXX is the port no
    4. Ok

    And you are connected to the Data model inside a Power BI Desktop file – The problem is the port no changes every time you close and open the Power BI File

    Three should be a straight forward way of doing this