Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Switch connection to a different Power BI Service Dataset without breaking calculated columns

Hi everyone,   I've been scratching my head over this the last couple of days. Whenever I switch the connection every calculated column remains in the table i originally created it in, keeping the...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous Well, with DAX Editor Pro (Enterprise DNA) you can select your columns, switch the Table and click Save to transfer the calculated column to another table. I really should release a free version of that tool...or maybe add that functionality to Metadata Mechanic.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Greg_Deckler

 

that would be more than fantastic! 😄 Do you know of any other sort of pain free way to transfer columns? 

 

Best regards and thanks as always for your replies!

Timo

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous I would think that Tabular Editor could do it if you wrote the C# code. I'll have to dig up my code for moving calculated columns and measures. There may be other third-party tools out there, I'd have to look around and see what's out there. With measures you can just change the Home table, but there's nothing native that I know with for calculated columns.