topic Re: Setting refresh times in Developer

Setting refresh times

jpaulson — Fri, 18 May 2018 15:58:29 GMT

Hello

First post from a newbie.

I want to set up a refresh time for a report that has source data from three places:

1) a view from sql

2) an excel spreadsheet on our network

3) a calendar table that I copied into the report

We have set up a gateway for the view. This alone seems to work if I delete the other two sources. In another test, I deleted the calendar table and left the other two sources. The gateway says I have links to the view and spreadsheet but still says that I am missing a link?

If we can get the first two to allow me to set up a refresh time, then I need to know how to insert the calendar table that was copied in.

Virtually all our systems are on premise.

I hope this makes sense. I really appreciate any help you can provie on my journey with Power BI

Justin

Re: Setting refresh times

v-jiascu-msft — Tue, 22 May 2018 02:32:36 GMT

Hi Justin,

1. What were the error messages or the prompt message?

2. Which gateway did you install?

3. If you used a on-premises gateway, did you add all the data sources in the gateway settings?

Best Regards,

Dale

Re: Setting refresh times

jpaulson — Fri, 25 May 2018 18:45:12 GMT

Hello Dale

1. What were the error messages or the prompt message? "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new data gateway or configure the data source for an existing data gateway"

2. Which gateway did you install? On-premises data gateway

3. If you used a on-premises gateway, did you add all the data sources in the gateway settings? I did some testing by deleting the copied in calendar and leaving a spreadsheet and sql view. After this was done, I still get the error message in number 1 above, even though when I "test" the two remaining connections it says the sources are connected.

If I eliminated the spreadsheet and leave just the sql view I can set up a refresh schedule and it refreshes. So, I need to know how to use an excel spreadsheet and a copied in table when trying to schedule a refresh.

I really appreciate you reaching out.

Thanks so much.

Justin Paulson

Re: Setting refresh times

v-jiascu-msft — Mon, 11 Jun 2018 03:20:14 GMT

Hi Justin,

If you configured all the data source in the data gateway, the gateway should be available. Please refer to the snapshot below.

Best Regards,

Dale