refresh pbix using api

[santiagomur]

hi, 

i have my pbix files on azure blob storage, what i trying to do is that when i made changes on the pbix file and i save the file on the blob store this trigger the import (refresh) the report on service. 

[v-kelly-msft · Accepted solution]

Hi @santiagomur ,

You just need to create a refresh schedule, the data will automatically update according to your schedule. As getting data from Azure,you don't need a gateway. I test it using the sample table in this post. I create a report, and publish it to service. 

In Power Service, please right click Dataset->Schedule Refresh, you will get the following screenshot. Please Edit Credentials using your Account. Turn on the "Keep your data up to date", and you can choose Daily/Weekly refresh frequency. Finally click the "Apply", the data will update automatically. 

In addition, if you want to refresh real time or at least every 10 mins. You will have two options.

For one thing, you can purchase Power BI Premium, there is no refresh frequency limitation for premium account. You can update data at least every10 mins. 

For another, for making reports up to date real time. You can create Azure Stream Analytics getting streaming IoT Data instead of Azure Storage Blob. Then you can create a real-time dashboard by Azure Stream Analytics. For more details, please review the following articles.

Get started with Azure Stream Analytics to process data from IoT devices
Stream Analytics and Power BI: A real-time analytics dashboard for streaming data

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Mariusz]

Hi @santiagomur 

don't know if you have the blob events but try power automate/flows 

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

or list of power automate options hire 

https://flow.microsoft.com/en-us/connectors/shared_azureblob/azure-blob-storage/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn