Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'd like to integrate Smartsheet based data into Power BI and then integrate Power BI in Microsoft Teams as a Tab.
Is there a way that data which is entered in Smartsheet can be (after refreshing the Microsoft Teams tab) visible in Microsoft Teams (in the Power BI tab)?
So far the only way I found to do this is:
1. saving any changes in Smartsheet
2. refresh the data in the Power BI Desktop App
3. publish again to the respective group
4. refresh the Teams tab with Power BI
This is way too complicated and not practical at all. Is there a way to synch this directly?
Thanks in advance!
Hi @MAICS
In power bi, it supports automatical refresh for smartsheet data.
1. Connect to smartsheet with Power bi desktop and publish it to power bi service,
2. Then you could go to this dataset-setting->schedule refresh->edit credentialm give the correct credential,
3. Once this set succeffully, data is refreshed automatically approximately every hour.
You can change that refresh frequency using the Scheduled cache refresh option, and set the refresh frequency.
reference:
https://docs.microsoft.com/en-us/power-bi/refresh-data#databases-in-the-cloud
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
But It seems when you use power bi tab in Microsoft Teams, the PowerBI tab will not refresh on its own.
You could get help from Microsoft Teams support forum.
https://support.office.com/en-us/teams
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-juanli-msft ,
thank you very much for your answer! Unfortunately, the proposed solution does not work.
1. The data does not refresh. It only refreshes if I import the data manually again from Smartsheet.
And then it also only synchronizes with Power BI web after publishing it again.
2. At the guide for scheduled refresh I only see the option "daily" or "weekly"
Have I missed something? I'd appreciate your help very much!
Best regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.