Forum Discussion
One drive refresh not working
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?
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.