Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop. This works fine as long as I don't change the data types. I have a text column which I want to convert to an integer. The column contains some dashes ('-') though, so before I change the type of the column, I filter out the rows with the dash. In Athena itself this works fine, on other databases it works fine. In Power Query with Athena as source, however, I get the below message:
"OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Simba] [ Athena] (1040) An error has been thrown from the AWS Athena client. Error Message: INVALID_CAST_ARGUMENT: Cannot cast '000000000-' to DOUBLE ..."
I don't want Athena to do the casting, I would rather let Power Query do it after importing the data. I am then sure the correct order is used. How can I make sure the conversion is done in Power Query and not pushed back to Athena?
Solved! Go to Solution.
Issue Table.StopFolding command to stop the operation being pushed back to the source. Example is given below
https://docs.microsoft.com/en-us/powerquery-m/table-stopfolding
Note - It doesn mean that you will lose the benefit of Query folding in successive operations.
Thank you Vijay_A_Verma, Table.StopFolding is exactly what I needed!
Issue Table.StopFolding command to stop the operation being pushed back to the source. Example is given below
https://docs.microsoft.com/en-us/powerquery-m/table-stopfolding
Note - It doesn mean that you will lose the benefit of Query folding in successive operations.
Hi, what if the source is not a table instead its a query.
let
Source = Odbc.Query("dsn=DW", "SELECT * FROM Table_name WHERE fiscyear >= 2020 ")
in
Source
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
18 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
23 | |
16 | |
14 | |
12 | |
12 |