Forum Discussion

tywoodworth's avatar
tywoodworth
Regular Visitor
5 years ago

Importing a .XLSB file from Teams

Hello,

 

I have a live excel file in Microsoft Teams that I would like to link to my Power BI report and then set it to refresh on a scheduled basis. I understand how to import the file using the web scource and then removing the last part of the link, however my problem is that the file is a XLSB binary excel file. The file is rather large so in order me to have it on Teams it has to be an XLSB to meet the size requirement. 

 

Any ideas on how I could do this? I don't want to have to download the file and save it as an XLSX everytime I want to refresh the data. Any help is great, thanks!

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mate! My problem was similar to yours but I think the solution will also aplly to you.


    I had a to load and combine data from reports in XLSX format, but one day my organization decided to change the format to XLSB. For that reason my queries didn´t load.

     

    I noticed that when you use XLSX the Source step on the "Transform file" custom fuction, specifies the "Item" and the "kind", but when you use an XLSB file the only difference is that the same Source step on the "transform file" function only uses the "Name" to specify where the data is.

     

    What I did was to change the source step on that custom function from Source{[Item="Sheet1",Kind="Sheet"]}[Data] to Source{[Name="Sheet1"]}[Data] 
    In my case, the data on each file was in a sheet called "Sheet1", you can replace that with the name of the sheet you have.
    Hope this could help.
    ragards, Kevin.

     

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    You're kinda stuck.  XLSB is not a good format for BI purposes.  See if you can get the size down on the XLSX version or use multiple XLSX files.

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi tywoodworth ，

    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

    Best Regards
    Lucien

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi mate! My problem was similar to yours but I think the solution will also aplly to you.


      I had a to load and combine data from reports in XLSX format, but one day my organization decided to change the format to XLSB. For that reason my queries didn´t load.

       

      I noticed that when you use XLSX the Source step on the "Transform file" custom fuction, specifies the "Item" and the "kind", but when you use an XLSB file the only difference is that the same Source step on the "transform file" function only uses the "Name" to specify where the data is.

       

      What I did was to change the source step on that custom function from Source{[Item="Sheet1",Kind="Sheet"]}[Data] to Source{[Name="Sheet1"]}[Data] 
      In my case, the data on each file was in a sheet called "Sheet1", you can replace that with the name of the sheet you have.
      Hope this could help.
      ragards, Kevin.