Forum Discussion
Resolver IIParameter Created from a query (part II)
Hi DiePic ,
Please try the following methods and check if they can solve your problem:
1.In the semantic model settings, try to review the credentials and connections are correctly configured.
2.Consider using the dynamic parameter.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
3.You can also view the following link to learn about the list parameter.
Parameters - Power Query | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IIthanks for reply Anonymous
In this PBI I've doing a great and large use of parameters statics and dynamics and as I've said it works in desktop mode ...
maybe in local with VPN my PC manage correctly times between parameters in xlsx file and record retrieved in sql with these parameters, but in service there was always errors in all the queries with dynamic parameters provided from xlsx queries. So I fell back on manage parameters directly on sql data with queries and subqueries inside (I've moved data from xlsx files inside sql tables).
Thanks for your help and interest