Reputation: 11221
I've recently created new experiment and set "Azure SQL Database" as data source. I've typed all necessary information to connect to database and I've run the experiment. Everything seems to be correct, but when I try to "Visualise" my data, some prompt at the bottom of the screen says:
Error producing the visualization of the output
And that's all. As well when I click "Visualise", a window appears with empty table (column names are correct, so it's sign that it's connected to database, because it had to get names of columns from db).
Where should I look for some additional information about why it doesn't work? What do you think could cause a problem? How to fix it?
EDIT: More info:
What I've already done is creating blank experiment and drag&drop "Reader" from "Data Input and Output". In "Reader" I've set "Data source" to "Azure SQL Database" and I've put login credentials. Database query: "SELECT * FROM Words" (Words is one of db tables).
Upvotes: 0
Views: 775
Reputation: 30162
Since I don't see experiment details and how it flows, let's start from the basics.
1. Ensure your data reader is correct and you have a query in it. I simply did select * from someschema.mytablename.
2. Route your output to a Convert to CSV.
3. Run your experiment and right click on the Convert task and download your dataset.
If you have data at this point the issue is elsewhere in your experiment. If you post more details about the experiment after trying this, I'd be happy to help :)
Upvotes: 1