Forum Discussion
One drive refresh not working
Hi, Yuliana, thank you for the answer!
I've tried using the Sharepoint Folder a few times, unefortunately in never worked for me :( Maybe because it is a business level one, to get to my one I need to go a subsubsite, a third leve/ and even so if I get data it bring data related to sharepoint (files I posted, dates, name of those files. It doesn't let me to retrive the data within the file). I had the same issue with Get Data> Web, that's why I ended up using the Onedrive folder on my computer, it was the only option that was connecting and letting others contribute. Would you know what I could be dong wrong?
I have posted my .pbix in the same folder in onedrive as the source Excel files, it didn't make any difference it refreshing. Works the same way. I wish I could install a gateway, but I don't have admin access to my computer (currently looking into that) However I've seen that gateways are recommended to be installed on a PC with wired internet connection and which is always on. I don't have an option like that. Would it be an issue to use my everyday laptop?
I wasn't aware it take 1 hour for the web refresh to work, I was always issuing a new link after refresh. I'll give that a try :)
Is web publish the usual way to go to share with people who don't have power BI? Or are there better options I'm not aware of? I did try the embed in Sharepoint link and it just looks like it's always loading. I'm not having much luck with Sharepoint :(
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.
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.