topic Re: Azure Logic Application refreshing Power BI Semantic Model tables in Developer

Azure Logic Application refreshing Power BI Semantic Model tables

PMFlorenzano — Tue, 24 Sep 2024 19:17:51 GMT

Hello,

We recently migrated our models from Azure Analysis Services over to Power BI Premium and used an MS Azure Logic App to refresh a series of tables within our model on a trigger basis.

Now that we are running our models within Power BI Premium, I'm trying to find a way/method to update these tables in the same fashion. The endpoint I use within SSMS starts with powerbi:// but the URI section does not like that syntax.

I even used the following URL but this didn't work either as I'm receiving 'Forbidden' / 'bad request' when executed the model.
https://api.powerbi.com/v1.0/myorg/groups/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/datasets/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/Refresh"}]}

Any help or information would be greatly appreciated

Thank you

Re: Azure Logic Application refreshing Power BI Semantic Model tables

lbendlin — Wed, 25 Sep 2024 00:31:28 GMT

The API call you are looking for is Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

You can specify tables and even partitions.

Re: Azure Logic Application refreshing Power BI Semantic Model tables

PMFlorenzano — Fri, 27 Sep 2024 12:42:16 GMT

Thank you very much @lbendlin, I'll give it a try!