I am using Power BI to analyze and share the cost data made available to us through the Internal Dataset Export. I have the Power BI application registered and enabled, and we are able to sync data manually from Foundry. We followed the setup steps and authorized using OAuth.
Right now our Power BI teammate has to manually sync data from Foundry. We would like to set up a foundry connection on a Power BI gateway so that the sync happens automatically. To our understanding this is only possible with token-based authentication.
I can generate a token easily, but when I pass it to the Power BI team they get this error
Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
I think I need to authorize the Power BI application for my user account. We read over this documentation on how to do that, which says " Attempting to connect or authorize a third-party application that has been registered and enabled will direct you to Foundry and open a confirmation screen".
We cannot find anything like that in our Power BI gateway, though. This is a lot of information, but my main question is this: has anyone else set up automatic syncing from Foundry to Power BI? If so, how did you do it?