Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have installed the on premises gateway and adding sql datasources works fine. When i want to connect to an Excel file (stored on a network share), i get an error: "Can't connect to mashup datasource". In the error details the following error is provided: "path must be a valid absolute path" However this does not seem to be the problem as the path is both valid as absolute. The excel file is stored on the same server as one of the sql datasources to which i am able to connect. What am i doing wrong?
Solved! Go to Solution.
Hi @TheoM,
When you mentioned the " i want to connect to an Excel file (stored on a network share) ", do you mean the Excel file shared via below way?
If that is a case, then you can create a file data source under the data gateway like below:
By the way, please update the data gateway to the latest version which can get out of potential issues.
Best Regards,
Qiuyun Yu
Hi @TheoM,
When you mentioned the " i want to connect to an Excel file (stored on a network share) ", do you mean the Excel file shared via below way?
If that is a case, then you can create a file data source under the data gateway like below:
By the way, please update the data gateway to the latest version which can get out of potential issues.
Best Regards,
Qiuyun Yu
Problem solved. In Power BI Desktop I referred to the excel file using the assigned drive letter (g:/), gateway does not accept that. I changed the datasource in Desktop, and referred directly to the domain root (\\....) and did the same in the gateway. Gateway now seems to work fine!