Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

refresh failed - teams channel as source

i have created power bi dashboard which tracks pre sales activity in my company, this dashboard is using file uploaded on teams channel as data source. currently i am using my company (OAuth2) creden...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi powerbiexpert22,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
    Thank you.

wardy912's avatar
wardy912
Icon for Super User rankSuper User
1 year ago

The easiest solution would be to create a service account.

 

  • Create a new user account in Microsoft 365 (e.g., [email protected]).
  • Ensure password policies in your organisation do not apply to the account.
  • Assign it the necessary permissions to access the Teams file or SharePoint folder where your data is stored.
  • Grant it a Power BI Pro license (or use Power BI Premium capacity if available).

Use this account to:

 

  • Connect to the data source in Power BI Desktop.
  • Publish the report to the Power BI Service.
  • Configure scheduled refresh using this account’s credentials.

This ensures that the refresh process is not tied to any individual employee