Forum Discussion

vikrantarora25's avatar
vikrantarora25
Helper I
5 years ago
Solved

Sourcing data from SQL using Power BI lists

Hi Folks, I have to source data from a SQL DB in Power BI and am using where clause in my query. I have created a Power BI list which has hundreds of IDs (integer type) and when I use text.combine...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi vikrantarora25 ,

     

    According to your needs, you should want to determine whether the [id] column of sql is in this ID list. The role of Text.Combine is to return the result of combining a list of text values into a single text value. You should create query parameters in power query and replace them in the advanced editor. I did a similar test, which can be used as a reference:

     

     

    related document link:

    Text.Combine - PowerQuery M | Microsoft Docs

    Pass parameter to SQL Queries statement using Power BI | MVP: Microsoft Azure | Channel 9 (msdn.com)


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi vikrantarora25 ,

 

According to your needs, you should want to determine whether the [id] column of sql is in this ID list. The role of Text.Combine is to return the result of combining a list of text values into a single text value. You should create query parameters in power query and replace them in the advanced editor. I did a similar test, which can be used as a reference:

 

 

related document link:

Text.Combine - PowerQuery M | Microsoft Docs

Pass parameter to SQL Queries statement using Power BI | MVP: Microsoft Azure | Channel 9 (msdn.com)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.