Forum Discussion
Power BI Service - Active Directory
I have succesfuly configure power bi desktop to connect to active directory, that part works well.
The main question I have is in order to share this report to others where the data is updated every 15 minutes, does this need a Power BI Server setup in order to make this work.
My current method is log into power bi desktop, hit refresh and re publish the report for others to see the up to date data.
Any feedback and guidance welcome.
Hi dskeane
After you've published your Report to Power BI you can configure automatic refresh to refresh the Dataset at regular intervals. If the original data in your report if from an "on-premise" source (an excel spreadsheet on your C: drive, or an internal MySQL Database, for example) you will need a working PowerBI Gateway to allow the refresh. If the data source is on a cloud-based repository (OneDrive, DropBox, MS Azure, etc.) you don't need a Gateway.
The refresh shedule depends on the PowerBI licence, you get 8 automated refreshes per day with a minimum 30 minutes between refreshes, per Dataset, with a Pro Licence. With a Premium Per User, or Premium Capacity licence you get up to 48 refreshes per day. Power BI's user interface restricts you to 30 minutes between refreshes, but if you use Power Automate or other API tools you can have refreshes with a minute or greater gap between them.
See Data refresh in Power BI - Power BI | Microsoft Docs
Hope this helps
Stuart
2 Replies
Hi dskeane
After you've published your Report to Power BI you can configure automatic refresh to refresh the Dataset at regular intervals. If the original data in your report if from an "on-premise" source (an excel spreadsheet on your C: drive, or an internal MySQL Database, for example) you will need a working PowerBI Gateway to allow the refresh. If the data source is on a cloud-based repository (OneDrive, DropBox, MS Azure, etc.) you don't need a Gateway.
The refresh shedule depends on the PowerBI licence, you get 8 automated refreshes per day with a minimum 30 minutes between refreshes, per Dataset, with a Pro Licence. With a Premium Per User, or Premium Capacity licence you get up to 48 refreshes per day. Power BI's user interface restricts you to 30 minutes between refreshes, but if you use Power Automate or other API tools you can have refreshes with a minute or greater gap between them.
See Data refresh in Power BI - Power BI | Microsoft Docs
Hope this helps
Stuart
Thank you it looks like I need to figure out how to configure the Power BI Gateway.
My setup is local device that pulls from an external dataset, then the report is published for other users to view.
I have Power BI Pro which I am assuming which will work in my favor for update intervalls.
