API REST planifier l'actualisation

[Anonymous_frenc]

J'utilise une API rest Tempo (Jira) pour collecter mes données sourcer de mon ERP et créer mes visuels. Cepeandant je ne peut planifier l'actuailsation, ce message s'affiche :

Vous ne pouvez pas planifier l'actualisation pour ce modèle sémantique, car les sources de données suivantes ne prennent actuellement pas en charge l'actualisation :

• Source de données pour Query1

Découvrir les sources de données

[v-mdharahman · Accepted solution]

Hi @Anonymous_frenc,

Thanks for reaching out to the Microsoft fabric community forum.

The message you are seeing means that Power BI doesn't support scheduled refresh for the data source used in Query1 because it's based on a REST API (Tempo in your case).

To fix this and enable refresh in the Power BI Service, you have a couple of options:

* Use an on-premises data gateway. Install the gateway on a machine that can access the API. Make sure your query is compatible (avoid dynamic or unsupported Power Query functions). After publishing to the Power BI Service, configure the gateway under dataset settings and provide the credentials.

* Or use an external ETL process (recommended for APIs). Use a tool like Power Automate, Azure Data Factory, or a script (Python, PowerShell) to pull data from the Tempo API at regular intervals. Store the data in a supported location (like OneDrive, SharePoint, Azure Blob, or a database). Connect Power BI to that storage location and set up scheduled refresh easily.

Additionally, in Power BI Desktop, go to Power Query and check the Applied Steps in Query1. If you're using Web.Contents(), make sure the URL is constructed correctly and that you've configured the Privacy Level and authentication method in a way that Power BI Service can understand.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

[v-mdharahman]

Hi @Anonymous_frenc,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well.

And if you're still looking for guidance, feel free to give us an update, we’re here for you.

Best Regards,
Hammad.

[v-mdharahman]

Hi @Anonymous_frenc,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

Best Regards,

Hammad.

[v-mdharahman]

Hi @Anonymous_frenc,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

Best Regards,

Hammad.