Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Refresh from file in BOX

Hi everyone, I have created my report in PowerBI using BOX to storage the source files, and I can Update my report with no problem. the issue is when somebody else (with access to BOX) wants to refr...
Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks Anonymous 

    so far the solution is to go into power query and change the data file location depending on the user BOX link.

    not the best solution, specially if you have many files linked in to PowerBI, but it works.....

    Regards

     

    Fabian C 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Yes, team members have full access to the folder where the sources of data are storage (write & read)

since we don’t have the license yet, we are sending the file's box link to final users.

The report has about 100 queries in 26 tabs, most of the source data is in excel files and a few images.

I hope this helps to help me, if you need more info, please let me know

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

How did you share your report to other users?
AFAIK, power bi not cache data credentials into pbix file. So if you direct share pbix file to other users, it not works due to invalid data credentials.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Anonymous 

    so far the solution is to go into power query and change the data file location depending on the user BOX link.

    not the best solution, specially if you have many files linked in to PowerBI, but it works.....

    Regards

     

    Fabian C