Forum Discussion

Paulo_Abreu's avatar
Paulo_Abreu
Frequent Visitor
3 years ago
Solved

Reload data problem via on premises gateway (Excel, Portugal locale)

Hi, need some help here, TIA!   Folder data source, excel files, column with decimal value converts fine, everything OK in Power BI Desktop Publish to Service, when it refreshes data (just after p...
Need Help
  • Paulo_Abreu's avatar
    Paulo_Abreu
    3 years ago

    Update, problem solved!

     

    For some reason PBI service has a problem dealing with "xls" compability mode files. Saving them as "xlsx" solved the problem, now its updating and showing data correctly

     

Paulo_Abreu's avatar
Paulo_Abreu
Frequent Visitor
3 years ago

Update!

 

Hi again, Sorry, problem now has nothing to do with the column data or what I posted above, I thought it was because of the 1st problem but it isn't - sorry for that

 

Problem now with the empty value is because the gateway can't access the network path where are the excel files, it complains with a DatasSource.Error I/O error 67 acessing the "Example file" on path "\\servername\Folder\ExampleFile.ls" ... Details: \\servername\folder

 

It works internally and gateway has the correct permissions... if anyone has a light ... but I'll check this, maybe something very obvious.

 

Thanks

Paulo_Abreu's avatar
Paulo_Abreu
Frequent Visitor
3 years ago

Update, problem solved!

 

For some reason PBI service has a problem dealing with "xls" compability mode files. Saving them as "xlsx" solved the problem, now its updating and showing data correctly