Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SAG28
Frequent Visitor

PBI Service, Dataset refresh fail - DataflowUnauthorizedError

Hi,

 

My dataset has been refreshing perfectly for the last 3 months, but for the past 3 days it will not refresh.

The dataset is refreshing from dataflows, which is in a workspace with premium capacity. The dataset is in a workspace without premium.

It's only in the service where the error occurs. If i refresh through PBI Desktop and publish, there is no problem.

Dataflows is also refreshing without problems.

 

Anybody who experienced the same issue?

 

Dataset refresh fail.png

1 ACCEPTED SOLUTION
SAG28
Frequent Visitor

@abujohn @Anonymous @crispybc 
Hi,

Got an answer from the support.

For me the problem was that i can't refreshing a dataset in a pro workspace that are getting data from dataflows in a PPU workspace. That's too bad because then PPU is kind of useless for me for now.

View solution in original post

8 REPLIES 8
SAG28
Frequent Visitor

@abujohn @Anonymous @crispybc 
Hi,

Got an answer from the support.

For me the problem was that i can't refreshing a dataset in a pro workspace that are getting data from dataflows in a PPU workspace. That's too bad because then PPU is kind of useless for me for now.

SAG28
Frequent Visitor

@abujohn @Anonymous @crispybc 

Thanks for the information 👍

 

I'm also refreshing locally and republishing, but this isn't durable.

It works if the setup is a dataflow and dataset in same workspace without premium capacity

Seems like it's an error in PBI service, when dataflow is in a premium per user workspace and dataset is in a workspace without premium.

I hope that PBI support will come with an answer today or tomorrow.

 

abujohn
Frequent Visitor

Support has responded, below was the sugested solution
but its not working, informed same to microsoft and waiting for next response

abujohn_0-1611233098223.png

abujohn_0-1611237533851.png

 

Anonymous
Not applicable

Thanks for posting the issue!
It was just coincidence that this happened in one of our datasets that don't require daily refreshes, so we were slow in testing the problem.

Have you perhaps created a Microsoft support ticket already?

I've created a MS support ticket yesterday, so hopefully they will answer soon.

abujohn
Frequent Visitor

Same issue here also,
The dataset is from dataflows, which is in a workspace,with per user premium trial.
the dataset is in a workspace without premium.
for the last few days, 

abujohn_0-1611193392413.png

it not refreshing on powerbi online service manualy or when scheduled.
Working around now by republishing the data set



Anonymous
Not applicable

Same issue here, also started on January 15th.
We are considering options on how to solve this, but refreshing locally and republishing is obviously not optimal for an extended period of time.

crispybc
Frequent Visitor

Exact same use-case and issue that your described.

First failure received on January 15, 2021 11:30 UTC and has not worked since. Currently I am working around it by refreshing the dataset locally then republishing it to the workspace.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors