Data Gateway not working

[TH]

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 again. So google told me to use the "on premise data gateway" which i installed, started and says to be online.

Now i try to connect my local excel workbook in the app.powerbi.com and get the following error:

Verbindungsherstellung nicht möglich: Beim Herstellen einer Verbindung mit C:\Users\aa\Desktop\ab\Pricingtool\bc\Aktuellster Stand ist ein Fehler aufgetreten. Details: "Mit der Mashupdatenquelle kann keine Verbindung hergestellt werden. Weitere Informationen finden Sie in den Fehlerdetails."Details ausblenden

Aktivitäts-ID:	b277a0e0-61ea-45ac-875a-7fc67bb8d6af
Anforderungs-ID:	49ba8b4c-a118-aeb1-c92a-40d1a8041215
Cluster-URI:	https://wabi-north-europe-redirect.analysis.windows.net
Statuscode:	400
Fehlercode:	DM_GWPipeline_Gateway_MashupDataAccessError
Zeit:	Mon Aug 14 2017 15:54:39 GMT+0200 (Mitteleuropäische Sommerzeit)
Version:	13.0.2080.159

Zugrunde liegender Fehlercode:	-2147467259
Zugrunde liegende Fehlermeldung:	Der Zugriff auf den Pfad "C:\Users\aa\Desktop\ab\Pricingtool\bc\Aktuellster Stand" wurde verweigert.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

Any ideas how to solve this problem? 

Thank you very much 🙂

Cheers

Thorsten

[v-qiuyu-msft]

Hi @TH,

If the Google translate works well, the error message should be below:

Unable to connect to connection: An error occurred while connecting to C: \ Users \ aa \ Desktop \ ab \ Pricingtool \ bc \ Details: "You can not connect to the Mashup data source. For more information, see the error details." Hide Details
Underlying error message: Access to the path "C: \ Users \ aa \ Desktop \ ab \ Pricingtool \ bc \ Current status" was denied.

In your scenario, it seems the dataset only have one data source which points to the local excel, right?

1. Make sure the machine which has on-premise data gateway run can communicate with the machine store the local Excel file.

2. Go to the Manage Gateways, create a File data source, use the same Excel path and credential as in Power BI desktop, double check if the Excel data source is Connection Successful status. Then go to the dataset settings, you can configure the dataset use this data gateway.

3. By the way, please try to update the data gateway to the latest version.

Best Regards,
Qiuyun Yu

[TH]

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 · Accepted solution]

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