I have a Power BI dashboard that has one table which is connected via a Kobo API and another table, which is appended to the first table, connected through Sharepoint. Initially, I had set up the connection using my Kobo username and password and the scheduled refresh was working just fine. However, it stopped working all of a sudden and I get the following error message “Information is needed in order to combine data;Information about a data source is required… The exception was raised by the IDbCommand interface. Table: Kobo.”
I deleted and published the dashboard again, and also changed Kobo credentials to “Anonymous” to see if that would help. But nothing seems to be working. This could very well be a Power BI issue and nothing to do with the Kobo API but just wanted to ask in case any other users are getting the same error message.
I believe the data is public (attaching screenshot).But please let me know if there’s anything else that I need to change in the settings for it to be public.
It should work despite the fact that the survey project was shared with you. Would you mind having a look at our support article and see if it helps solve your issue:
I changed the credentials to anonymous, privacy level setting to public. Then I cleared cache from Power BI and disabled parallel loading. One (or a combination) of these steps seems to have done the trick.