Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Power BI Report builder query parameters sends null to database
12-07-2023
10:20 PM
I'm calling a proceedure in MariaDB. I noticed that when the query is parameterized, it doesn't send the values I added to the parameters. So I created this sample proceedure where it returns the values it received back.
CREATE DEFINER=`root`@`localhost` PROCEDURE `reporting_db`.`proc_Hello`(
IN `P_StartDate` DATE,
IN `P_EndDate` DATE
)
DETERMINISTIC
begin
SELECT `P_StartDate`, `P_EndDate`;
END
When I hardcode the start date and the end date, I get the result back correctly. (Here, start date parameter has a default value of 2020-01-01)
When parameterized however, query sends null instead.
For parameterized start date, I get back null.
I tried changing start date and end date to varchar(50) in the proceedure but result is the same. What is wrong here?
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024
11:25 PM
Hi,
I have the same issue. Did you find any solution for this?
Thank you!

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |