Forum Discussion
jaryszek
Super User
Super User2 datasets or parameters to upload report within customer tenant?
Hi Guys, I will be uploading reports using service principal on Customer tenant. And now I have switcher while using report internally within my Team - parameter to change Local Data Source (C...
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!!
v-sathmakuri
Community Support
Community SupportHi jaryszek ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you!!