Queries Metadata Loading data into Model Fail

0 votes

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.

Nov 16, 2020 in Power BI by anonymous
• 10,520 points
638 views

1 answer to this question.

0 votes

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...

answered Nov 16, 2020 by Gitika
• 65,910 points

Related Questions In Power BI

0 votes
1 answer

how to connect firebase data into power bi

Hi, @There, Click “Get Data->Blank Query” to add ...READ MORE

answered Dec 18, 2020 in Power BI by Gitika
• 65,910 points
2,362 views
0 votes
1 answer

Scalable Power BI data model on delta lake ADLS Gen2

You may use the new Delta Sharing ...READ MORE

answered Feb 17, 2022 in Power BI by CoolCoder
• 4,400 points
1,639 views
0 votes
1 answer

PowerBI Data Model and Slicers for Many-to-Many-to-Many too Many Over Time

A relationship with a many-many cardinality in Power BI ...READ MORE

answered Mar 2, 2022 in Power BI by gaurav
• 23,260 points
1,710 views
0 votes
1 answer

Profile all the data tables

you can automatically get a profile for ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 52,360 points
572 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
964 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
77,081 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
18,550 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,180 points
591 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

answered Oct 22, 2020 in Power BI by anonymous
• 65,910 points
1,411 views
0 votes
1 answer

how to sync firebase data into power bi?

Hi, @There, As far as I know, it ...READ MORE

answered Dec 18, 2020 in Power BI by Gitika
• 65,910 points
581 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP