cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerardoRTobar
Regular Visitor

Information is needed in order to combine data EVEN WITH ORGANIZATIONAL LEVEL

I actually have a dataset that uses two different SharePoints as data source to merge and to append some tables.

 

I read a post where it was supposedly solved, but it is only solved for when you use Gateways, and that is not my case.

I already have Organizational Level set up in both Power BI Desktop and PowerBI Service Data Source Settings, and nothins is yet solved.

It refreshes fine in the Desktop, with no error, but as soon as the automatic or manual refresh happens in the service, it shows me that error.

 

I would really appreciate any help with this.

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

Hi @GerardoRTobar ,

 

I have found the same issue is submitted to microsoft. The team is working on it now. I'll let you know as soon as there is some solution.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

13 REPLIES 13
David_BI
Regular Visitor

Hello,

 

I have the same issue. It started on Sunday 25/07.

 

It works when I try to update the pbix from the Power BI Desktop. It only fails when I try to update it directly from Power BI Web.

 

Best regards

Today it has started to work again.

Laurenz
Frequent Visitor

Same issue here. Started on monday.

Laurenz
Frequent Visitor

I reported it yesterday as support ticket to Microsoft. Today the refesh is working again as expected.

Doodle
Helper II
Helper II

Encountering the same issue. There are several threads on this issue right now...hope the team can help resolve it soon.

janpaul
Frequent Visitor

The issue resolved itself. It is working for me now.

v-deddai1-msft
Community Support
Community Support

Hi @GerardoRTobar ,

 

I have found the same issue is submitted to microsoft. The team is working on it now. I'll let you know as soon as there is some solution.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

Thanks a lot! It has in fact been solved already!

Now the refreshes are even faster as I can relate, but I don't know if it's only my perception.

Thank you and everyone for your kind help!

Hello, actually today It worked to me like nothing happened. What I did was not anything technical, but I just set the privacy level to public and then back again to organizational, and then it worked.

I will wait until another automated refresh in order to confirm this as a Solution, but for the meantime thanks for your help.

lbendlin
Super User III
Super User III

Go to the sharepoint data sources in your dataset settings, edit credentials and set the data privacy levels accordingly.

 

lbendlin_0-1627390543291.png

 

Hello, Ibendin.

 

I have already done that, as I stated above, I already did what the post I attached says, and nothing worked.

 

Do you know any other workaround?

 

Thanks for your reply

Hi @GerardoRTobarI ran into the same problem. For me the problem started two days ago. For some reason the datasets will still refresh in a certain workspace. This can be due to the fact that this is a premium capacity workspace, or simply that the dataset and dataflow are in the same workspace. Still trying to figure out what causes it exactly.

Same for me! The datasets were working just fine until friday or saturday night.

 

All of my datasets in that Workspace are suffering from this, but all of the datasets in my Personal Workspace do too...

 

It is not a known error by now in the PowerBI service, is it?

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.