Forum Discussion
RaedTattan
1 year agoNew Member
SSRS to Powrer BI Builder
We are currently working on migrating approximately 15 SSRS (v 2012) reports to the latest version of Power BI Report Builder. The issue I'm facing is that everything works fine when I open the repo...
- 1 year ago
Hello !
Thank you for posting on Fabric community !
Hard to tell without seeing the original file but here is my assumption so far :
- If parameters are dependent on one another (cashier list is filtered based on branch), and if one of the upstream parameters has no value downstream ones appear blank or inactive.
- In SSRS, default values might have worked fine via expressions or queries but in PBI service, if default values are missing or not set correctly, the parameter UI may break.
- If a parameter uses a dataset to populate available values, and that dataset errors out or returns no data on the PBI service, the parameter remains blank or inactive.
- If the dataset requires a gateway (on-prem SQL), and it’s not properly configured in the PBI service, then the datasets that feed parameters can fail.
- PBI Report Builder does not support cascading multi-value parameters the same way as SSRS. Also, expressions like =Today() in default values can behave differently.
Try to check the points I mentioned you will for certain find the issue ! 😄
v-dineshya
Community Support
1 year agoHi @RaedTattan ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
v-dineshya
Community Support
1 year agoHi @RaedTattan ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh