Hi everyone, I am doing a report which carries many data sources (access file, excel files and D365CRM). The report is done in Power BI Desktop and refresh without any error. I uploaded the repo...
Hello,
I have the exact same problem. 3 Access Databases are connected over the Gateway administered through our IT. After the first attempt the Gateway server couldn’t open the Access database, Access Database Engine was missing. It was installed and tested. Now I get the same error as the OP.
DataFormat.Error for every Database. Tried the solutions from Anonymous, nothing worked. Searched for table format errors in PowerBi Desktop but there seems to be everything fine. The Access Databases are imported as File.