Importing a .XLSB file from Teams

[tywoodworth]

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!

[Anonymous]

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.

[v-luwang-msft]

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]

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.

[v-luwang-msft]

Hi @tywoodworth ,

The suggestion to have a macro in the xlsb file that creates an xlsx copy and to have the power query connected to the xlsx is a good tip.

rfer:

https://exceleratorbi.com.au/importing-xlsb-into-power-bi/

https://excelgorilla.com/power-bi/power-query/error-reading-xlsb/

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[lbendlin]

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.