I am having trouble getting report builder to retrieve data, either with a new query or with existing ones.
I have installed the report builder 5.2, the 32 bit version which matches my version of excel 2010.
I am able to login with my credentials and connect successfully.
I've tried creating a brand new report in a brand new workbook. Clicking the 'Create' item in the ribbon opens the report suite and I can see the report suite and all options. I choose to create a simple report, using just yesterday's date and the Site Totals. I added an Applies metric to the report and click finish.It prompts me to select a cell in the new worksheet, and then it tries to build the report. I see "Queuing report" and "Queued" and "Retrieving data" and then a pop up comes up with "An error occured."
No other information is given and the data never comes back.
I have a few other reports in a saved workbook which were created with the 4.7 version of Report Builder that I've also tried. In the Manage window, when I highlight one of them, I get the error “Please Exit the Excel Cell with focus before using this feature”, even though I’m not in a cell. If I try to refresh them, it spins on the Retrieving data, but never comes back. Sometimes it also gives the "An error occured" error with no other detail.
Any help is greatly appreciated, this is blocking the creation of reports that I need to get up and running.
