Forum Discussion
ludovith
6 years agoRegular Visitor
Error during BI cloud refresh with access as linked source
My two linked sources from onedrive (excel and access 64bit) works fine in the Power BI destkop. Even refresh is ok. But there is problem with refresh in BI cloud. If I have BI just with one s...
ludovith
6 years agoRegular Visitor
I got now one answer... Microsoft is not supporting accdb, only xlsx and csv format.
But Excel can have just 1 million rows and we need tens millions rows, that is why we use access as a source for powerBI. So what can we do now?
Can we maybe user some azure webconnector? Is there some quide how to do it?
v-eachen-msft
6 years agoCommunity Support
Hi ludovith ,
I think you could try Azure SQL Database. You could also post your ideas here, maybe Power BI will support accdb file in the future.