Data Public Necessary for Query Links? [NO, it is not]

[nat]

Greetings @BPlayfair123 and welcome to the community.

I do a lot of PBI + PowerQuery/Excel integration and can assure you that you do not need to make the data public in order to connect to PowerBI or PowerQuery/Excel. You can keep it private and use Basic Authentication (i.e. KoBo username and password) to connect.

Agree that the documentation needs to be updated (as the info on the support site is currently wrong as per the below). @Kal_Lam may you or someone else in the KoBo team please update the doco?

Data Confidential after tick on "Anyone can view submissions made to this form"

Greetings @sreangphaly I’m not sure what tools you are using to automate the process of pulling data out, but if for example you are automating using Power Query in Excel or using Power BI then you should not need to make your data public - please see this other thread for some links: If you are automating using other tools to call the API then again as long as you are authenticated then you will be able to access the information. I realise that the documentation on the KoBo support site Exc…

KoBo - Tips & Tricks (Power BI, email notifications, listing projects etc.)

Hey Quentin. The data actually does not need to be public in order for this method to work. You will be using basic authentication through Power Bi, so no need to make the data public. Cheers! Z

Thanks all