I pulled data using power query and during loading the data, it should this message mentioned below
Initialization of the data source failed while pulling query from kobo.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database.
Could you kindly share with us the link you used to query. Maybe we could help you out it there is any issue with it.
Besides, you could also have a look at our support article Pulling Data Into Excel Power Query to learn more if you have missed out any steps accidentally.
Hi Mandar,
I would suggest repeating the process of sharing the data publicly again. If you put the link your browser, it should download the data directly; that is always a quick check to see that. I would also suggest you recheck your specific steps.