Forum Discussion

appsheetglm's avatar
appsheetglm
Regular Visitor
7 years ago
Solved

RESOLVED - Refresh Onedrive Data after sharing by email

I've built a PowerBI for a collegue and I've sent it to him by email. The database is an Excel file on a Onedrive.  When he tries to refresh the data, an error message appears saying that he cannot ...
Need Help
  • appsheetglm's avatar
    appsheetglm
    7 years ago

    I was able to fix this issue.

     

    1. I've moved the Excel spreadsheet to a Sharepoint Site
    2. I added my coworker as a member of my Sharepoint Site
    3. I've change the PowerBI source for a Sharepoint Folder (site link as URL)
    4. Than was able to navigate to my Excel Spreadsheet
    5. I  than sent the PowerBI by email to my coworker
    6. When the user clicked on Refresh for the first time, he must log in with the same Windows credentials than the ones that were added to the Sharepoint Site

     

    I hope this will help people,

    Regards,

     

appsheetglm's avatar
appsheetglm
Regular Visitor
7 years ago

I was able to fix this issue.

 

  1. I've moved the Excel spreadsheet to a Sharepoint Site
  2. I added my coworker as a member of my Sharepoint Site
  3. I've change the PowerBI source for a Sharepoint Folder (site link as URL)
  4. Than was able to navigate to my Excel Spreadsheet
  5. I  than sent the PowerBI by email to my coworker
  6. When the user clicked on Refresh for the first time, he must log in with the same Windows credentials than the ones that were added to the Sharepoint Site

 

I hope this will help people,

Regards,

 

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi appsheetglm 

Thanks for sharing,please accept your reply as solution, that way, other community members will easily find the solution when they get same issue.

Regards,