Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am using an ODBC mongodb PowerBI connector to connect and filter my data. I am using the following query:
SELECT *
FROM [03.MyTable]
WHERE [Activities] LIKE '%1234-0001%';
-- Modify the data type of the Timestamp column
ALTER TABLE [03.MyTable]
ALTER COLUMN [Timestamp] TIMESTAMP;
I am able to return only values where Activities contains 1234-0001, however, the data type for the "Timestamp" column is still showing as Text instead of TIMESTAMP. I know i can change this later in PowerBI, but I'd like to do this with the SQL.
Any help would be appreciated. Thanks in advance!
@mpereiraTFF , Can you type cast it in the select statement?
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |