Forum Discussion
Transfer pbix file offline
Ok, So on your friends machine. Open Power BI Desktop application - Edit Queries. This will open the Query Editor window.
On Ribbon - click View - Advanced Editor. This will opent eh Advanced Editor window.
This should look something like
let Source = Excel.Workbook(File.Contents("path\of\the\excelfile.xlsx", null, true)Change the "path\of\the\excelfile.xlsx" to the proper location. The file path on both machine would be different.
In case, you want the filepath to remain same for all user in your network, insert the filepath along with the network address/IP address of the file. Your IT department may be of help here.
IP path would look something like
\\192.168.1.0\powerbi\myfolder\Excelfile.xlsx
Regards,
Vasim Shaikh
Helper IOk, So on your friends machine. Open Power BI Desktop application - Edit Queries. This will open the Query Editor window.
On Ribbon - click View - Advanced Editor. This will opent eh Advanced Editor window.
This should look something like
let
Source = Excel.Workbook(File.Contents("path\of\the\excelfile.xlsx", null, true)
Change the "path\of\the\excelfile.xlsx" to the proper location. The file path on both machine would be different.
In case, you want the filepath to remain same for all user in your network, insert the filepath along with the network address/IP address of the file. Your IT department may be of help here.
IP path would look something like
\\192.168.1.0\powerbi\myfolder\Excelfile.xlsx
Regards,
Vasim Shaikh
Helper IHi Vasim Shaikh,
I tried but the .pbix file created in Win 7 Power BI in my new Win10 laptop but get an error message - "We're unable to access file storage" ! Can't therefore reach the stage of Edit Queries !
Further if I try to create a new file on Win10 laptopn I get an error message "The ....file is already open in Power BI Desktop or another program" !
Stuck badly..pl help !
Thx
Inder