Forum Discussion
Power BI service and Dropbox
Hi!
I actually found a much more simpler solution to this.
I add the file to Dropbox. Go to dropbox.com, then I choose Share on that specific file. Instead of sending a mail with a share I choose Copy Link.
Here's an example:
https://www.dropbox.com/s/yyxxqhka4t7eee1x/Salary.xlsx?dl=0
If a user clicks on that link he/she get's the htmlversion of that file. To get the actual file I change the parameter to:
https://www.dropbox.com/s/yyxxqhka4t7eee1x/Salary.xlsx?dl=1
That gives me the Excel file back. In Power BI I have to log on to Dropbox to access it but after that it's no problem doing refresh through the Power BI service.
Regards,
Magnus
Hi!
I actually found a much more simpler solution to this.
I add the file to Dropbox. Go to dropbox.com, then I choose Share on that specific file. Instead of sending a mail with a share I choose Copy Link.
Here's an example:
https://www.dropbox.com/s/yyxxqhka4t7eee1x/Salary.xlsx?dl=0
If a user clicks on that link he/she get's the htmlversion of that file. To get the actual file I change the parameter to:
https://www.dropbox.com/s/yyxxqhka4t7eee1x/Salary.xlsx?dl=1
That gives me the Excel file back. In Power BI I have to log on to Dropbox to access it but after that it's no problem doing refresh through the Power BI service.
Regards,
Magnus
Magnus, I got copied my link in Dropbox, but I'm not sure what to do with it? What do you mean by in Power BI, log on to Dropbox?
MagnusSthlm wrote:
I add the file to Dropbox. Go to dropbox.com, then I choose Share on that specific file. Instead of sending a mail with a share I choose Copy Link.
That gives me the Excel file back. In Power BI I have to log on to Dropbox to access it but after that it's no problem doing refresh through the Power BI service.