none
Power Query renamig tables issue RRS feed

  • Question

  • I am wondering why renaming tables using Power Query add-in to excel causes data model destruction? I mean all measures stored in this table disappear. Table losing relationships and crushes pivot tables in Excel.

    Why it is not fixed yet? Any workaround?

    (sorry I could not find PQ forum here)

    Wednesday, October 11, 2017 3:26 PM

Answers

  • It is fixed. Upgrade to Excel 2016 (which is almost 2 years old now). Both Power Query and Power Pivot were built as addins and hence proper integrations was difficult. Excel 2013 was a big improvement because Power Pivot was integrated. 2016 both products are integrated.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, October 12, 2017 8:46 PM
    Answerer

All replies

  • Hi Bartek,

    Thanks for your question.

    According to your description, your problem is more related to Power Query. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in Power Query forum:  https://social.technet.microsoft.com/Forums/en-us/home?forum=powerquery ,you will get a more professional support from there, thank you for your understanding and support.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Thursday, October 12, 2017 5:51 AM
    Moderator
  • It is fixed. Upgrade to Excel 2016 (which is almost 2 years old now). Both Power Query and Power Pivot were built as addins and hence proper integrations was difficult. Excel 2013 was a big improvement because Power Pivot was integrated. 2016 both products are integrated.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, October 12, 2017 8:46 PM
    Answerer
  • It is easy to say, upgrade to Excel 2016. I would like to but a decision not belongs to me. (Global organization)

    So it means I can not expect to make it fixed in 2013 PQ add-in?

    Friday, October 13, 2017 7:59 AM
  • Hi Bartek,

    Thanks for your response.

    As I said in my last reply for this question, I would still recommend you to post your question to Power Query forum for a better support.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, October 17, 2017 2:17 AM
    Moderator