Forum Discussion

VivianaTudora's avatar
VivianaTudora
Frequent Visitor
7 years ago

One drive refresh not working

Hi everyone,    I am looking into creating a report which has an automatic refresh and a source which can be edited by multiple users.  I found out Onedrive would be suitable for this and it won't...
Need Help
VivianaTudora's avatar
VivianaTudora
Frequent Visitor
7 years ago

Hi again!

 

I've not used SPO before, but I don't have the option of using a table, the data will be replaced weekly and it's a lot of files to be transformed into tables. :smileysad:

I'm sure I'm doing some silly mistake just not sure what, 

Don't think so, I always change data sources in the Dektop app. Is there an option to do that in the online version?

What do you mean by credentials? I change different Excel files as data source for each report. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In order to schedule a data refresh in the Power BI service I have to sign in (just once) using my O365 organizational account (email).

 

Too bad you can't sell your users on SPO list, no more files and in data sheet view it behaves very similar to Excel and exports to Excel if needed. Our office had hundreds of Excel files flying around in emails collecting all kinds of data and I have all but eliminated them, we use SharePoint lists.