Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

selectcolumns and directquery

Hi, I work with a dataset in directquery mode, that I can't change and they don't want to change. There is a table in the datamodel not in a relationship to the tables that ARE in a relationship, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Gabriel. The problem is that I'm working with a dataset where I'm not the owner and don't have permissions to change it.  As a result, I don't have the ability to copy or reference any of the tables in the dataset.  Those menu options are unavailable to me.

But I've created a few local tables, and THOSE  I can copy or reference.

I hope that helps?

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous, 

     

    Maybe you can try this code to copy the directqueryTable.

    Table = FILTER('directqueryTable',TRUE())
    However, the table will not update until you refresh the data manually. Normally, you cannot join to this table, which I understand to mean that you have no way to create other relationships for this table because other relationships already exist. Please let me know if I'm misunderstanding.Or you can add a new connection to this table in power query.
     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.