Forum Discussion

davidebrevi's avatar
davidebrevi
Advocate I
9 years ago
Solved

onedrive

Dear community, I'm experiencing an issue trying to use in a model an excel file coming from OneDrive For Business service.   I'm able to connect to the service, navigate my OneDrive folders, sele...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Do you have a data model in your Excel file?

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

davidebrevi

 

Are you experiencing this same issue for all the excel files in your OneDrive Business?

How about the result if you move this excel file to your local location, and try to get data from Local File instead of OneDrive Business?

BTW, could you please give a screenshot while the issue happens?

 

Best Regards,

Herbert

  • davidebrevi's avatar
    davidebrevi
    Advocate I
    9 years ago

    I identified the source of the problem.

    Data were not formatted as table,

      so PowerBI service was not able to load the data,

      but PowerBI desktop was able to load it.

     

    Unfortunately I can't load data from OneDrive with PowerBI desktop,

    or at least, I don't know how to...

     

    Thank you