I have a file coming from a EDI system daily in the form of a csv file. I want to use it in Power BI Services. This works locally and personally however when I publish the Power BI report online in Power BI Services and attempt to refresh the report that has both SQL and this CSV file I get sync (refresh errors) just for the CSV. So I want to send the file to a SQL Server Database Table daily (once at about 7am) from the MS OneDrive for Business csv file. the file is new every day and always the same name: HCOInv.csv. So does Zapier support this and how difficult is it to setup?
Best answer by PaulKortman
View original