OLEDB or ODBC error external table not in the expected format

[smjzahid]

I have a dataflow which throws this error (on refresh) on PBI Service, I have tested this on 2 different laptops and throws the same error on both machines.

I do not understand why its asking me to download Access DB OLEDB, when dataflow refresh is run in Power BI Service (not on local laptop) so nothing to do with 

after copying the query from the dataflow and runnin the same in PBI DESKTOP it throws different error (PBI Desktop)

[v-easonf-msft]

Hi, @smjzahid 

What is the datasource corresponding to your dataflow?

Can you access the data source normally on your local laptop?

Please check if this thread could help.

OLE DB- eller ODBC-fel: [DataFormatError]External table is not in the expected format 

Best Regards,
Community Support Team _ Eason