Forum Discussion

clem312's avatar
clem312
Icon for Resolver I rankResolver I
4 years ago
Solved

Analyze in Excel does not export links between tables

Hi evryone,   I have tried to export My Power BI report from online service with Analyze in Excel.  But when I get the data in my Excel sheet, the links between tables don't exist anymore. Is tha...
Need Help
  • MikeJohnsonZA's avatar
    MikeJohnsonZA
    4 years ago

    All relationships and measures would also work in [analyse in Excel] if you are not getting the correct filtering behaviour then I would check those relationships in the model.

    You can also test by creating a report against the same model in the service.

     

     

     

    I would validate that these relationships are correct

MikeJohnsonZA's avatar
MikeJohnsonZA
Icon for Responsive Resident rankResponsive Resident
4 years ago

Hi

[Export Data] and [Analyse in excel] are two separate functions. When you export data you will get a static export of the data that is currently in the visual (such as a table) this data will not change if you make any changes to your report. [Analyse in excel] creates a live pivot table connection to your Power BI model that allows uses to create reports in excel but is completely disconnected from the Power BI report(it does have a connection to the same dataset). 

You will need to recreate the table/report in excel, applying the same fields, measures, and, filters.