topic Re: New Semantic Model refresh activity - refresh unsuccessfully successful in Pipelines

New Semantic Model refresh activity - refresh unsuccessfully successful

MG86 — Thu, 30 May 2024 13:51:33 GMT

Unfortunately I get some unexpected results with the new semantic model activity. I used it in a simple pipeline with schedule to refresh dataflows, upon success the semantic model is refreshed.

The pipeline completes without errors, the dataflows refresh and have verified that the data there is refreshed. The semantic model _appears_ to have been refreshed as the refresh time is updated and no warnings in the workspace. However, when I open the report running on top of the semantic model, the data actually has not been updated. When I run a manual refresh in the workspace it does update the data.

When looking at the refresh history for the semantic model I see that the 'on demand' and 'scheduled' refreshes took about ~2 minutes, while the 'Via Enhanced Api' type that is triggered by the pipeline activity only takes 6 seconds despite not returning an error.

In the JSON output of the pipeline it also shows each individual table as 'succesful'

I tried building in a 5 minute Wait activity in between, to account for a possible delay of the dataflow actually being populated, but it made no difference.

Could it be I need to be a tenant admin? The documentation says 'tenant account', but to me that just seems any xx@tenant.xx with a PBI license. I'm also the owner of the semantic model btw.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Sun, 14 Apr 2024 19:25:48 GMT

I got an error, but not sure if it is the same issue:

First I was able to run it and then I got an error after setting it up to scheduled refresh, with the following error message:
semantic model refresh {"error":{"code":"InvalidRequest","message":"data ID belongs to a shared capacity."}}

The semantic model was import from the Lakehouse, but publised to a workspace which is not attached to a Fabric Capacity. Is this a limitation (I did not find any information).

Publised the model to a Fabric capacity workspace instead and it seems to work.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Mon, 15 Apr 2024 18:17:12 GMT

Hello MG86 ,

Thanks for using Fabric Community.
nAt this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

chris__1 — Tue, 16 Apr 2024 11:26:07 GMT

MG86 wrote:

When looking at the refresh history for the semantic model I see that the 'on demand' and 'scheduled' refreshes took about ~2 minutes, while the 'Via Enhanced Api' type that is triggered by the pipeline activity only takes 6 seconds despite not returning an error.

I can confirm the exact same behaviour unfortunately!

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

marco_parravano — Fri, 19 Apr 2024 09:52:26 GMT

Same problem here.

I created a simple PowerBI report with this data for a simple test: Source = DateTime.LocalNow().

When Semantic Model is refreshed manually or scheduled you can see datetime label updated in report but when it is refreshed through pipeline activity it will be marked as refreshed but data it's not.

I'm sure somebody is already working on this so thank you in advance.

Marco

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Tue, 23 Apr 2024 10:50:04 GMT

Hi MG86 ,

CC: marco_parravano , chris__1 , Anonymous

Apologize for the issue you are facing. The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

DC07 — Wed, 24 Apr 2024 13:45:21 GMT

same here. anyone open a ticket?

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

marco_parravano — Wed, 24 Apr 2024 13:47:49 GMT

Hi, I did. They're looking into it.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

robertostaino — Wed, 24 Apr 2024 13:50:23 GMT

I did too, they made me redo most of the things, unsuccesfully. They transfered the request to another team, cause the guy helping me wasn't able to solve the problem.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Thu, 25 Apr 2024 07:24:19 GMT

Hi MG86 ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket.

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

MichaelTH — Fri, 26 Apr 2024 18:02:37 GMT

Hi, I have the same issue, and I've submitted a support ticket: 2404230040008403

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

rarelyamson — Mon, 29 Apr 2024 19:13:33 GMT

Any update on this. Not working for me either.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Mon, 29 Apr 2024 19:36:39 GMT

Not yet,

I have ongoing support and sent more information to the team.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

kevingauv — Tue, 30 Apr 2024 17:22:51 GMT

Same issue here. I'm the admin of the capacity. Test ont 3 different Semantic Model (import mode), always the same issue.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

kevingauv — Thu, 02 May 2024 12:14:55 GMT

Hi Anonymous ,

Any update on this? I saw the post ont the Fabric Blog yesterday about this feature, however, it seems that we are a bunch of people that are not able to use it.

Thx in advance.

Kevin

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

MG86 — Thu, 02 May 2024 16:07:18 GMT

Hi, didn't get around creating a support ticket. Here is the ticket number: 2405020050003928

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Thu, 02 May 2024 19:26:21 GMT

From LinkedIn in a post:
"The fix is going out this week to all tenants. Please keep an eye out for next week that you’re seeing the appropriate refresh state"

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

marco_parravano — Mon, 06 May 2024 10:59:11 GMT

Today my test semantic model is correctly refreshed through pipeline semantic model refresh activity. So are other semantic models with data from various sources. It seems this issue has been solved but I'll keep monitoring to see if it breaks again before using it for real.

Many thanks to anyone working on it.

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

Anonymous — Mon, 06 May 2024 11:10:12 GMT

It seems to work for me too.
Thanks!

Re: New Semantic Model refresh activity - refresh unsuccessfully successful

kevingauv — Mon, 06 May 2024 12:17:05 GMT

It's working on our side too.

Thx averyone!