Blog Post

Power BI Community Blog
2 MIN READ

Use Column as Parameter for Custom Function in Power Query

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago
Scenario:    In query editor, you can use parameter as a filter option.  You can use parameters when defining connection properties. For example, if you retrieve data from SQL Server, you can use o...
Published 5 years ago
Version 1.0
Combine queries
Create function
parameter
Support insights
tips & tricks
V-lianl-msft's avatar
Community Support
Joined October 29, 2019
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
menglaro78's avatar
menglaro78
Microsoft Employee
5 years ago

Hi,

I tried the same technique having "Sharepoint Online List" as source.

In this case the whole URL must become a parameter.

 

When I invoke the function all it's ok, after when i try to expande a table, it returns this error: 

 

I tried to clear the permission, but after having entered the credentials again I still get the error.

Obviously if I don't use the function, I log in without problems.

 

Any Idea?

Thanks