Change source for a table contained in the main file without recreating DAX formulas RRS feed

  • Question

  • HI,

    I have a table included in the main file where all power pivots are built. Id like to take it out and start soucing the data from an external source in excel. This table can get very large and id like to optimize the use of the power pivots.

    Table Properties is not an available option and since its coming from the same file I dont see the connection in the source menu either. How can i take the table out from my file and change source?

    Thanks in advance!

    Friday, January 31, 2020 3:25 PM