none
Exporting from Project to Excel RRS feed

  • Question

  • Hi all, I have set up a map and am exporting my project data to excel and then using the saved excel file as the data source for my PowerBI report. Everything has been working fine until yesterday, when it started to export just the column headers only without any data. I have tried rebuilding the map from scratch and it is doing the same thing. 

    Some things to note:

    -all files are saved in a SharePoint folder, I did try saving the export locally and encountered the same problems. 

    - I have tried ensuring that there are no filters active on any columns before exporting (but dont think this makes a difference)

    Any help would be greatly appreciated! 

    Thursday, March 26, 2020 9:34 AM

All replies

  • Sounds like a filter is applied on the site or permissions have changed in the PWA profile.

    When you open the view, do you see all the data before it is exported?


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Friday, March 27, 2020 3:46 AM
    Moderator
  • Hi Michael,

    Thanks for the reply. Yes I tried different views. I moved all the files out of SharePoint folder to a OneDrive folder and the issue stopped. Do you know why that could be?

    Mia

    Monday, March 30, 2020 4:20 PM