Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Bokangmaela
Frequent Visitor

Power BI Custom connector

Good day, 

 

I have built a custom connector in visual studio to connect to a custom datasource. I am however struggle adding and IF statement in the function as I see that it indicates an error when I add one. Here is a simple code snipt of that I am trying to do. 

 

Connect = (url as text, count as number) =>
let   

If count< 1 then samplecount = 1 else samplecount= count,
response = Json.Document( Web.Contents(url, [ samplecount]))
in
response;

 

I am not sure if it is a limitation of the PowerBI connector SDK or I am not following the examples online correctly. Please share same insight if possible. 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Bokangmaela 

 

Try changing the first statement into below:

 

samplecount = If count < 1 then 1 else count,

 

The second statement also has an error. Web.Contents function expects to have a record parameter after the url. The samplecount should be passed to a valid field in the record. Web.Contents - PowerQuery M | Microsoft Learn

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Bokangmaela 

 

Try changing the first statement into below:

 

samplecount = If count < 1 then 1 else count,

 

The second statement also has an error. Web.Contents function expects to have a record parameter after the url. The samplecount should be passed to a valid field in the record. Web.Contents - PowerQuery M | Microsoft Learn

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

That worked, thanks a lot!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.