ThuJa23
4 years agoAdvocate II
Status:
Investigating
DataFormat.error when refreshing in Power BI Service
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...
Trelobar
4 years agoRegular Visitor
Hello ThuJa23
I finally solved my problem, hope it also helps you. My access file is saved on a server. I can access it as a network drive. In the explorer you see the network drive with the folder name and in brackets the server address. I assumed that the server address is the one in the brackets, but it was false. Right klick on the network drive, settings, and under the “DFS” tab is the right address.
Changed the address in the gateway and in PowerBi Desktop and now it refreshes over the online service.
Hope it helps you.