Report blank when using parameters

[forantes]

Hello everyone!

I'm working with PBI Paginated Reports in Report Builder.

I'm creating a report that uses 3 parameters: StartDate, EndDate and Type (as a dropdown list from a dataset).

The report works fine on the desktop, it shows all the information once given the parameters. I'm using an ODBC connection for this report.

However, when I publish the report to my Premium workspace, the report returns no data. 

After some research, I figured out this happens when I'm using the parameters. If I remove the parameters from the report, the data loads simply fine. 

Any idea how to fix this?

[forantes]

I just realized the issue with parameters is for the ones that are dates 😪 

Leaving the Type parameter only, works fine on the workspace

[forantes]

I FIXED THIS!!!!

I found this article --> Using Date Pickers in Power BI Report Builder (coeo.com)

Basically, In the tab for Parameters into the DataSet Properties, the ones using DateTime picker, I added the following function 

=Format((Parameters!<your_parameter_name>.Value), "yyyy-MM-dd")

It worked! 🌟

[Anonymous]

Hi @forantes 

I am so glad to hear that you have fixed your issue . I will change the status to "Delivered" so that other users who have same issues can deal with their issues through your method .

Best Regards,
Community Support Team _ Ailsa Tao