Parameter Created from a query (part II)

[DiePic]

referring to my previous post "Parameter created from a query" https://community.fabric.microsoft.com/t5/Desktop/Parameter-Created-from-a-query/mp/3698482#M1206003
(  @v-junyant-msft _)

.........

I have a parameter (a list of names) retrieved from an Excel (stored in sharepoint) file, then a SQL query with this list where.

In my PBI the desktop works, but in the service it sends me an error:

If I put the list in a text parameter, it works in desktop and in service.... but this list is dynamic so I can't put it in a static list.
Any help or ideas to solve this problem will be appreciated

Thanks in advance

[DiePic]

thanks for reply @v-jiewu-msft 
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 

[v-jiewu-msft · Accepted solution]

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.