Forum Discussion
How to create a reference table in VS or tabular Editor
Hi Anonymous ,
If you are trying to connect to the data source with live connection mode, then it is not available to duplicate the date table by creating a calculated table or going into the Power Quer Editor to copy or reference the table. Perhaps you could consider doing this on your side of the data source (copying the date table). Or you can provide some sample data and the results you want and we will see later if there are other alternatives.
The Easy Way to Duplicate Tables in Power BI
Best Regards
Hello there Anonymous ! In Power Query you have the option to create a reference table. To do so, open PQ editor and right click on the table you wish to reference and select the "Reference" option. This creates a second table that keep all changes that were made in the original table and will maintain any further change.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Unfortunately I cannot work with Power Query, as I work with a live connexion. Changes in de model need to be done in Visual Studio or Tabular Editor. You have another suggestion?
Hi Anonymous ,
If you are trying to connect to the data source with live connection mode, then it is not available to duplicate the date table by creating a calculated table or going into the Power Quer Editor to copy or reference the table. Perhaps you could consider doing this on your side of the data source (copying the date table). Or you can provide some sample data and the results you want and we will see later if there are other alternatives.
The Easy Way to Duplicate Tables in Power BI
Best Regards
A very unsatisfying, but expected answer. We will import another date table. Thanks for answering though!