Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

ERROR [42000] [Cache ODBC][State : 37000][Native Code 12]

Hello, I am currently using the Power BI Report Builder tool to generate a report that involves dynamic parameters. However, I have encountered an error message whenever I attempt to create and imple...
Need Help
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

If you are using Power BI Report Builder, the error probably comes from the "@BeginDate" part.

 

Can you first test whether this query can return you the correct data if giving it a specific date value with the correct format required by the data source? For example use '2020-10-12'. 

 

If you are sure which date format the data source requires and your query can work correctly with a specific date, then you may need to convert the paramter to the correct format. For example: =Format(Parameters!BeginDate.Value, "yyyy-MM-dd")

 

The following links may be helpful:

Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn

Report Builder Parameter Formatting (Datetime to Date) - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello, Thank you for your feedback. Unfortunately, I am still getting errors after applying your suggestion. Do you have any other option you can think of. 

Thanks