Forum Discussion

sudarshanalwara's avatar
sudarshanalwara
Regular Visitor
8 years ago

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

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

Data Modeling
Reports

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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