Forum Discussion
Anonymous
6 years agoNot applicable
Recommended Workflow
Hi, I'll be creating a dashboard to be embedded on our sharepoint site. Could you clarify a few things: Our data is mostly sharepoint lists (also an access database and potentially a workbook on sh...
Mariusz
Community Champion
6 years agoHi Anonymous
1. Yes, you are correct, Power BI Desktop is still more powerfull then service in terms of functionality and it's a lot faster to mashup all different data sources there.
2. Normally I would use Desktop for design, please refer to above.
3. If you need to get data from SharePoint go to Get Data in Desktop or New Data source in the Query Editor and find SharePoint connectors as below.
4. Or else you using Direct Query or Streaming Datasets, you will need to set up a scheduled refresh, pro users can set up to 8 a day per dataset and premium up to 48, I imagine you just need to time it.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.

If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Anonymous
6 years agoNot applicable
Thanks a lot for your response. I'll be working on it over the next week and ask any questions if I stumble upon any problem.