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
Icon for Helper I rankHelper 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

 

  • inderz's avatar
    inderz
    Icon for Helper I rankHelper I
    9 years ago

    Hi 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

  • inderz's avatar
    inderz
    Icon for Helper I rankHelper I
    9 years ago

    Hi 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

  • 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

  • aliraza2688's avatar
    aliraza2688
    New Member
    8 years ago

    Its work for me. Amazing with thanks