Forum Discussion

joglidden's avatar
joglidden
Advocate III
10 years ago
Solved

New Table greyed out...

Why is 'New Table' greyed out (unavailable) in one pbi desktop file but not another? It seems so random. I can't find a reason for this. Any insight would be appreciated.  
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi joglidden,

     

    In the DirectQuery mode, no data is imported or copied into Power BI Desktop, and all tables must come from a single database. Due to the nature of the DirectQuery mode, we are not able to create a new table. Currently, we can only use DAX expressions to create calculated columns or measures in this mode. For more information, please refer to this article: Use DirectQuery in Power BI Desktop.

     

    If you have any feedback about DirectQuery mode, you can submit an idea in Power BI Ideas forum.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi joglidden,

 

In the DirectQuery mode, no data is imported or copied into Power BI Desktop, and all tables must come from a single database. Due to the nature of the DirectQuery mode, we are not able to create a new table. Currently, we can only use DAX expressions to create calculated columns or measures in this mode. For more information, please refer to this article: Use DirectQuery in Power BI Desktop.

 

If you have any feedback about DirectQuery mode, you can submit an idea in Power BI Ideas forum.

 

Best Regards,
Qiuyun Yu

joglidden's avatar
joglidden
Advocate III
10 years ago

Thank you for explaining this to me. I wanted to create a table to organize my measures, so the real problem here is organizing and managing measures. I hope that Power BI eventually comes up with a better approach for this.