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 ...
Data Modeling
Reports
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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