Forum Discussion
Helper IIshare a pbix if the data source is excel
Hi!
I created a report with the data pulled from an excel file that is stored on my computer. Now I need to send this report to another person so that he can update those excel files. How do I do that?
Or I can upload the pbix to Power BI service and how this person will update the excel files?
Thank you!
That's correct
Dropbox is a cloud storage. No need to access his dropbox account.
If you do right click on file then you have the option to 'Share the file'
Then select the 'Can View' option (not 'Can Edit') from the section:
Anyone with this link: can view
Then Copy link
Change Number from zero to one
Add it to PowerBI as mentioned on previous message
14 Replies
- themistoklis
Community Champion
Do you want the other person to get the data from PowerBI and update his own excel files?
Maria_MariaHi themistoklis
I created a report for another person and he/she will be updating the excel files (the data source) on his/her computer.
If I send just a pbix to them, the source excel files will still be on my computer.
If I share the report with them via Power BI Service, it won't fix the problem, the excel files will still be on my laptop as I created the pbix on it.
And they have Mac so the option to open Power BI Desktop and change the source is not an option either(Is there any way to solve this?
Thanks!- themistoklis
Can you put these files somewhere in the cloud (shared folder).
E.g. DropBox, OneDrive, Sharepoint
If yes then you can add the files there and add the dropbox or OneDrive link to PowerBI report