query view

2 Topics

Oklahoma Power BI and Fabric User Group Meeting January 2024
Review several features that have been released in late 2023, including, but not limited to.... The DAX Query View The new INFO functions available in Power BI Many more... Microsoft Teams meeting Join on your computer, mobile app or room device Click here to join the meeting Meeting ID: 288 328 027 913 Passcode: ehtm6t Download Teams | Join on the web Or call in (audio only) +1 872-239-6107,,133049325# United States, Chicago Phone Conference ID: 133 049 325# Find a local number | Reset PIN Learn More | Meeting options
brentlightsey
14 days ago Place Oklahoma Power BI User Group
294Views
0likes
0Comments
Working with DATATBALE in Query View! Is this some kind of bug or am I doing something wrong?
I was playing around with the Query View in Power BI Desktop. I wanted to create a table from scratch without importing from any source and then I wanted to show output of the table also perform some calculations on it later. I thought of using Table Constructor first but as it doesn't allow to give names to the columns directly so I used DATATABLE instead. I tried to run this query in the Query View: DEFINE VAR Sample_Table = DATATABLE( "First Name",STRING, "Last Name",STRING, "Time",DATETIME, { {"Reza","Rad",0}, {"Leila","Etaati",}, {"someone",,"2019-2-10"}, {"Unknown",blank(),"2019-2-10"} } ) EVALUATE EVALUATEANDLOG(Sample_Table) Then I got the error: "DAX Evaluate queries work only on databases which have at least one tables." Now after searching on google and asking copilot, I didn't get anything relevant to this. Then finally I decided to make a Calculated Table and as usual it worked and I could perform all the operations. Now I tried once again to debug the previous code. So I deleted that Caluclated Table and then ran the query, that I've provided above, in the Query View. To my surprise, the query ran and gave the output. I thought it maybe because of cache so I canged the values in DATATABLE and again the query gave output with changed values. To summarize this, I am providing the recording of the same. Please tell if this is some kind of bug or is there something wrong with the code. Link to Video
Solved
SidArt0731
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
4Comments