Forum Discussion
Advocate IIUnable to change Parameters in Workspace semantics.
Was able to configure the reason in the M code. Able to work it out with Mass Filter.
Hi rnola16 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
Advocate IIBasic query:
Select A.ssn, A.birth-dt
From Emp A where A.ssn in ( '"¶m_ssn&"') and A.birth_dt between '"&Start_dt&"' and '"&End_dt&"'.
This is using teradata as data source, custom SQL, direct query and the table has 15bill records.
I'd like the query to have the user input parameters and running it on the dat source. Haven't found any solutions, can Power BI handle large datsets and user defined input parameters ?
- lbendlin
Super User
Only if all possible values of your query parameters are known and loaded in import mode. Sounds like your scenario is not allowing that
- rnola16
I do not want to load 'all possible values'. Its a simple 'where' clause with user defined inputs.
Hi rnola16 ,
Thanks for sharing the additional details. Since you have already explored options like Dynamic M Query Parameters and report slicers, and are still running into limitations which didn't provided the resolution.I would recommend you to raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Hope this helps.If so,consider acceptin git as solution.
Thank you for being a part of Microsoft Fabric Community Forum!
Regards,
Pallavi.
- rnola16
Was able to configure the reason in the M code. Able to work it out with Mass Filter.
