Forum Discussion

Jkreisel's avatar
Jkreisel
New Member
4 years ago

I miss Proterties with Direct Query

Hi,

I imported my dataset via Direct Query, but I don#t have the opinion to choose the properties of the dimensions.

I am missing to load at least the key. Does anybody know how to solve it?

Is ist even possible to have Direcht Query and an imported Query in one Dataset.

Once I have added a Direct Query all the other methods to add data are dimmed.

Can I change that - maybe in  the options??

 

I saw a post to have mixed queries in, probably somebody hat already solved this problem?

 

Need Help

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi， Jkreisel ，

    There are no such limitations when in DirectQuery connection mode. The lower right corner of the desktop will display the current connection mode. Please check if you are in Live connection mode.

    If you are using Live connection mode and the data source is a Power BI dataset or Azure Analysis Services, you can change the connection mode from Live connection to DirectQuery for more functionality. If not, you can only edit from the data source to create a new table.

    Attached document for reference.

    Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs

    Or what is your data source?


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.