Forum Discussion
How to know that a table is a reference table?
Hi Phil,
thanks for the quick reply.
I was very surprised to hear that PowerBi cannot "research back" if it is a standalone dupicate or a reference which adapts to the changes in the original data. I find thats important to know, especially if its an old project and you don't know what you did back then. As far I know reference doesn't need to load data from the source, only from the original import which it refers to. Thats a big difference.
So I dig deeper and found where the connection can be seen afterwards:
In PowerQuery there is the button "query dependancies" in Views.
Hi Applicable88
You can't tell unless you name the table something like Ref_xxxxx, or you could add a Description in the Query Properties that appears as a tooltip when you hover your mouse over the table name, or you check the Source step in PQ.
Regards
Phil
Hi Phil,
thanks for the quick reply.
I was very surprised to hear that PowerBi cannot "research back" if it is a standalone dupicate or a reference which adapts to the changes in the original data. I find thats important to know, especially if its an old project and you don't know what you did back then. As far I know reference doesn't need to load data from the source, only from the original import which it refers to. Thats a big difference.
So I dig deeper and found where the connection can be seen afterwards:
In PowerQuery there is the button "query dependancies" in Views.