Forum Discussion
Helper IBest Way to Design PowerBI Reports with Access Database stored in Sharepoint Online
swan1099 You'll need to install the on-premises data gateway. I would create all your reports in Power BI Desktop first, this will provide you flexibility in so many ways. Create and use a Group Workspace to publish the reports to, this will allow multiple users to be able to manage the reports instead of just one person.
When you deploy the Desktop reports, a dataset will be created for each set of reports you publish. The dataset can be scheduled to refresh up to 8x per day, this is set up and done in the Service.
There was a new way to easily embed into SharePoint Online, but it does require certain version etc., but it's really straightforward. Otherwise you would need to do some custom DEV to embed.
Helper IHello Anonymous,
Thank you for your comments, I do appreciate the advice. I've downloaded & installed the gateway, and for the life of me, cannot get the gateway to add our sharepoint site as a data source.
Any thoughts on what may be holding me up? It looks like I'm being hung up in the username/password area, but I've tried my o365 credentials as well as my ActiveD credentials...it won't accept either?
Thanks!
- swan1099
Anonymous This appears to be exactly what I was looking for -- I can do some trial and error I suppose, but will this method of connecting to the data not require a data gateway? That would be ideal!
Hi swan1099,
How do you host Access database in SharePoint Online? According to my knowledge, all of Access tables become SharePoint lists, and records become list items.
This way, you can connect to SharePoint Online list from Power BI Desktop, create reports there and publish them to Power BI Service, it doesn't require gateway when you refresh the dataset in Power BI Service.
Thanks,
Lydia Zhang