Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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