2 datasets or parameters to upload report within customer tenant?

Hi jaryszek ,

As i suggested above, avoid relying on parameter switching at runtime.

• Power BI evaluates all branches of the if condition during dataset refresh (even unused ones), so just having CSV logic in the query causes refresh to fail, unless it's a cloud-accessible file.
• A data gateway is always required for on-prem SQL Server, regardless of whether conditional logic is used.
• To completely avoid issues, try to maintain consistency across every environment with respect to data sources to avoid failures in the higher environments as well.

Could you please let us know if you have any additional questions?

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!