cancel
Showing results for 
Search instead for 
Did you mean: 
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 @elsadp @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 @elsadp @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

SAG28
Frequent Visitor

@abujohn @elsadp @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

 

elsadp
Frequent Visitor

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?

SAG28
Frequent Visitor

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



elsadp
Frequent Visitor

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
Regular 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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors