Power Bi

Nikki17

Hi there!

I have created a report in Power Bi and have embedded into Smartsheet Dashboard.

1. How do I not have it show sign in on dashboard?
2. How do I have data refresh automatically on dashboard without having to go to PowerBi and manually refresh?

Data is connected with Smartsheet connector in PowerBi

Thanks in advance

heyjay

Can you try using the publish to web (public) instead of the other one. Please also make sure you are publishing non confidential items.

The refresh depends on PBI, there is an option to refresh on schedule in power bi data set.

Nikki17

I cannot publish to web as there is information that cannot be public. I did set up refresh but it is only daily. Is there a way to set up to push automation when Smartsheet is updated in real time? Also, do I need to do this:

https://smartsheet-platform.github.io/odbc-docs/#getting-started?

I used the Smartsheet connector.

Thanks for the help!