Forum Discussion

Shree_185's avatar
Shree_185
Icon for Helper I rankHelper I
4 years ago
Solved

How to create new table in Direct query mode

Hi everyone,   As enter data option is grayed out in the direct query, how to create a table in the PBI
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Shree_185 ,

     

    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

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data