Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Transfer pbix file offline

Dear community,   i'm currently using Power BI Desktop. I would like to share my evaluations with a friend of mine. He's also using Power BI Desktop.   We both have not signed in for a 365 accoun...
  • vasim07's avatar
    vasim07
    10 years ago

    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

     

vasim07's avatar
vasim07
Helper I
10 years ago

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

 

Zara's avatar
Zara
Regular Visitor
9 years ago

Thank you. 

 

I had to take further steps  in order to source file address get fixed.

After changing the address again I went through query settings pane , clicked on  source and manually changed the addresses for all excel sheets I had there.

 

I am running two different versions of  Power BI Desktop  on two devices.

 

Regards, 

Zara