Reply
srineshnisala
Frequent Visitor

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)

srineshnisala_0-1702015688317.png

srineshnisala_1-1702015710935.png

 

When parameterized however, query sends null instead.

 

srineshnisala_2-1702015812816.pngsrineshnisala_3-1702015830647.png

srineshnisala_4-1702015858278.pngsrineshnisala_5-1702015873395.png

 

For parameterized start date, I get back null.

srineshnisala_6-1702016118909.png

 

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
mihalytorok
New Member

Hi,

 

I have the same issue. Did you find any solution for this?

 

Thank you!

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)