Forum Discussion

Piscus's avatar
Piscus
New Member
11 years ago
Solved

DataFormat.Error: The supplied file path must be a valid absolute path.

Hi, I am trying to use Power BI Desktop and I am facing a problem when selecting an excel file as a data source. My excel file is on my SharePoint 2013 (on premises environment). I can navigate and se...
  • andre's avatar
    andre
    11 years ago

    You should be able to source from an excel file in your sharepoint by doing GetData->From Web then pasting the link to your excel file.

     

    I just tried it and it worked.

ckinghorn's avatar
ckinghorn
New Member
10 years ago

I think a cleaner way of doing this is to create your query using excel to write the query. Open the advanced editor, and then copy and paste from Excel advanced editor to power BI editor. This has just worked for me and allowed the connection.