Queries Metadata Loading data into Model Fail

Question

I am using Power BI Desktop and DirectQuery to get tables from a SQL data source.

I created a new table by clicking the New Table button and called it "Trip". I used the Distinct() DAX function to create the values for the first column of the new "Trip" table. I also created three additional columns using other DAX functions such as Lookupvalue() and if().

My problem is that I cannot delete any of the Trip table columns. When I try to delete the column I get "Something went wrong" error.

Answer 1

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.

Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions.  The ability to define a calculated table using a DAX expression isn't supported in DirectQuery mode.

For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#modeling-limitation...