Excel power query not functioning as expected

cherifmad · May 2, 2021, 12:59pm

hello dear,
When I follow the step of [Pulling Data Into Excel Power Query — KoBoToolbox documentation](https://Pulling Data Into Excel Power Query) an error appear.

.
How can I make it ?
Thanks for your understanding

Kal_Lam · May 2, 2021, 1:08pm

Welcome to the community, @cherifmad! Looking at your issue it seems like you are using the wrong project in the API i.e. 735479 may not be the correct one. Try checking out your project correctly as outlined in the support article and reach us back if you still need support.

cherifmad · May 3, 2021, 11:33pm

Thank you for your answer but I tried the whole process of This tutorial , I searched for the link of my project like this picture

in Sublime text editor. I copied the link and followed the next step but, the error appears again. How can I solve it ?
Thanks for your understanding

Kal_Lam · May 4, 2021, 6:08am

@cherifmad, would you mind sharing with us the following through a private message so that we could have a closer look at your case:

Username
Project name
Server

cherifmad · May 4, 2021, 8:24am

Ok… I send you message. Thanks for all

Kal_Lam · May 4, 2021, 8:29am

Sorry, I have not received your private message so far. Let us know when you have shared it with us.

cherifmad · May 4, 2021, 8:38am

Please dear, reload your message… I sent you 2 messages with all information you need to help me. Thanks for your supporting

Kal_Lam · May 4, 2021, 8:39am

I now received them @cherifmad. Will get back to you soon!

Kal_Lam · May 4, 2021, 9:00am

@cherifmad, make your data public from SETTINGS>Sharing as shown in the image shared below:

And you should be able to access your data in the Excel Power Query.

cherifmad · May 4, 2021, 9:55am

Thank you very much for your support. If I have a suggestion to help Kobotoolbox, how can I share my idea?

Kal_Lam · May 4, 2021, 9:59am

That’s great! You could create a new post for the same. I shall then categorize it accordingly.

cherifmad · November 18, 2021, 7:24pm

Hi @Kal_Lam I need some information in this “button” as I click, what is the meaning please? Does everyone have access to the data I publish via the Kobotoolbox API?

Kal_Lam · November 19, 2021, 5:24am

Welcome back to the community, @cherifmad! Would you mind sharing the screenshot of the button you are trying to refer to? That should be helpful for the community to understand your issue pictorially.