Forum Discussion

TH's avatar
TH
Regular Visitor
9 years ago
Solved

Data Gateway not working

Hey guys, so i am trying to get the local excel sheet connected to the app.powerbi.com after i uploaded the dataset there. Unofortunately i was not able to refresh the data after i worked on it agai...
Need Help
TH's avatar
TH
Regular Visitor
9 years ago

Hi Quiyun,

 

yeah you are right. That is the english translation. And you are also right about the scenario that there is only one local excel as data source which i try to link.

 

1. The machine says it is online 

 

2. When i try to bind in the excel file (as you do it in the first picture) is where my error occurs (the error from the starting post)

 

If i try to go for the dataset settings to plan the timing for an refresh i simply can not get to the point to time it. The shown message says something like "we can not plan to refresh your data since the dataset has no datamodel linking or the data source is a work sheet. The data should be added to a datamodel to plan updating."

--> I think this is, because i am not able to link it first in the data gateway?

 

Thanks in advance

Thorsten

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi TH,

 

Did you get data from local Excel file via "Import Excel data into Power BI " in Power BI service directly? And get below second image when you go to dataset settings?

 

 

 

If it is, it doesn't require any gateway. The reason is below from Notes section in this article: Refresh a dataset created from an Excel workbook on a local drive

 

Refresh is not supported for Excel workbooks imported from a local drive where data exists only in  worksheets or linked tables. Refresh is supported for worksheet data if it is stored and imported from OneDrive. To learn more, see Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online.

 

Best Regards,
QiuyunYu