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...
juleshorton you change it in the Report settings one the File tab on the upper left side.
Once you added the datasource, you change the source path for the access document to the right address (full servername with path)
My problem was that then I added the file, stored on our server, to Power BI. It saves the local path saved on my computer (M:datasource/file.accdb)
The onlineservices can't find the file because the full serverpath is false. I changed it to the serverpath and now the onlineservices are able to find the file. (\\servername\filestorage\datasource\file.accdb)