Failed Schedule Refresh - "Information is needed in order to combine data"

[win_anthony]

I successfully published a report and am using a personal gateway which is importing data from SQL Server. In the report, I loaded an Excel table which was used to append to my main table being imported from SQL Server. After I appended the two tables, I made sure to not include in report refresh (unchecking the box "Include in Report Refresh") the Excel table. I also tried unchecking "Enable Load". All of my attempts have not been successful at refreshing the report. 

Any advice on how I can have a successful refresh? Anything that I am missing? Your advice is greatly appreciated. 

[selimovd · Accepted solution]

Hey @win_anthony ,

try to copy the result of the table and paste it with "Enter data".

Then remove the Excel. That should work.

The personal gateway should also be able to handle local Excel files. If the file is in c:\temp\myExel.xlsx the gatway should find it at the same spot.

You can also upload the Excel to OneDrive for Business and then directly connect to the online file.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic