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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Would it be possible to store your data in an SPO list? you can use the "Import Spreadsheet" feature to create your list form Excel (make sure the excel data is a table) then you can follow my steps, connect to an SPO list, upload the .pbix, connect from PBI service, Publish to web then you insert a script editor web part on any SPO page and paste the code snippet from PBI service.

 

are you able to edit credentials in the data source porperties in Power BI service?

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.