Issue while fetching data from xlsb to power bi - DataFormat.Error: External table is not in the exp

[sudarshanalwara]

Hello there,

I read a few posts related to this issue of getting data from xlsb to power bi - and I have tried implementing all relavant solutions, however, it still does not fetch data to power bi file.

I have also installed Access Database Engine for 64bit - no luck.

Please could you help me get this done - ASAP.

Regards,

Sudarshan

[v-jiascu-msft]

Hi @sudarshanalwara,

How is the issue now?

Best Regards,

Dale

[v-jiascu-msft]

Hi Sudarshan,

It works fine in my test. 

1. What's in the xlsb file?

2. Can you share a dummy sample?

3. Did you try to organize your Excel data as tables?

Best Regards!

Dale