Hello,
I'm building an Analytic App that I need to publish on my Gallery, and the app needs to show some dropdowns tools that need to be connected to a SQL Server table (the options of the drop down tool should vary depending on the SQL table).
For example, I have a drop down tool in my App that should be connected to the a table in my SQL Server instance, so that the end user can select which information he wants from the SQL table, and then continue running the App.
I configured my drop down tools with External Source and my query works fine when I run it from outside the Gallery (as a regular Analytic App), but whenever I try to run it from the Gallery, the drop down do not show the options (it stays empty).
OBS: I have already configured my SQL Server connection to my Gallery and have access to it (I managed to write data in my DB from the Gallery Analytic App).
This is how I configured my Drop Down tool with a List Values from an External Source:
And this is the result I get from the regular Analytic App running from my server, which shows that the drop down is reading the SQL table:
When I publish my App on the Gallery (which is on the same server), the drop down options don't appear:
Is there any way my App on the Gallery will connect to the SQL Server instance and show the drop down options from the live SQL table?
Thanks in advance!
