- 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
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I have the same issue. Did you find any solution for this?
Thank you!

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |