cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Online service giving errors and not refreshing but desktop version fine

Hello,

I've been using Power BI Pro since October in our organisation and it's a great BI tool. However we've had a dashboard running for a few months (the datasource is a sharepoint list) and I've recently updated the dashboard to include the new preview table as we have long text to display so the word wrapping feature is a fantastic addition.

 

I've published a new version with a different name and all of a sudden the new datasets are not refreshing in the online service, on the desktop version it refreshes fine with no erros but once in the online service the on demand and scheduled refreshes fail.

The error messages is the following:

 

"An error occurred while processing the data in the dataset.
The column 'HasUniqueRoleAssignments' of the table wasn't found.
Next refresh for Accidents Incidents v1.5a is scheduled for 05/11/2017 07:00:00.
Learn more
Technical Information:
Activity Id: ed5dba45-e117-415b-acff-8eed771b4c69
Request Id: 260b4c12-4c36-4ed8-b5d0-f4e6749cbfa8
Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Refresh Start Time: 05/10/2017 08:02:06Z
Refresh End Time: 05/10/2017 08:15:46Z"

 

I've checked the queries and the column is displaying fine and I don't use the column in any parts of the query so I'm at a bit of a loss as to why on the desktop version I can refresh the data with no errors but once published then there's errors.

I've tried re-publishing in the workspace and in a different workspace. I've even gone back to the previous version and published that and the same error occurs.

 

Help needed please!

15 REPLIES 15
Highlighted
Helper II
Helper II

Re: Online service giving errors and not refreshing but desktop version fine

I have this exact same problem. 

Highlighted
Helper I
Helper I

Re: Online service giving errors and not refreshing but desktop version fine

I did think it might be the new preview table causing the error but have test versions with and without and still failing, it seems to be a Saherpoint issue? It started same time as the BI service yesterday so I think it might be related to that.

Highlighted
Helper II
Helper II

Re: Online service giving errors and not refreshing but desktop version fine

Is your datasource also SharePoint Online?

Highlighted
Helper I
Helper I

Re: Online service giving errors and not refreshing but desktop version fine

Yep, I think something has gone a bit wrong within the PBI service and O365

Highlighted
Advocate II
Advocate II

Re: Online service giving errors and not refreshing but desktop version fine

I just got off the phone with Msft.  

 

This issue seems to be isolated to the May release of PowerBI desktop.  I have confirmed that by uploading a report directly into the web service via the "Get Data" button on the web service prevents this issue from happening.  

 

Unfortunately, if you have already downloaded and saved the .pbix file in the May release... the default authenticatoin columns have been added.  I am working on getting a previous release version from archive and testing if it's possible to roll back a version of a saved .pbix file and re-publish with March release version.  

 

Stay tuned.. 

Highlighted
Helper I
Helper I

Re: Online service giving errors and not refreshing but desktop version fine

I've raised a tech support ticket and was given a work-around of to use "remove other columns" as a workround. I've re-built the affected report both from an open query approach and then the removing other columns approach. Neither have worked, if the problematic columns are removed it just flags other related columns as not found. I've got it to the point where client_title column is causing issues if I remove it or not remove it. Without major assistance from MS techies, I can't see a viabe solution at the moment. Sad times!

Highlighted
Advocate II
Advocate II

Re: Online service giving errors and not refreshing but desktop version fine

It seems that the problem is, the columns that are being entered, specifically "hasuniqueroleassignment" "DisplayName" "Complianceinfo" etc etc, are added in to the data table by PowerBI desktop application.  They do this for authenitication of some sort.  

 

The web service does not seem to be updated along with the desktop version and since the columns do not exsist in SP Online, but instead are added into the file at the desktop application stage, the web version cannot find them online and throws the error.  

 

Even if you remove the columns the service will still throw an error becuase it has to run the script to find those columns and remove them.  I've tested just about every workaround with the May release and there is nothing I can come up with.  My goal for today is to at least get this recognized as a full scale work stopping bug and top priority on MSFT end.

Highlighted
Helper I
Helper I

Re: Online service giving errors and not refreshing but desktop version fine

^^^ This. In a nutshell is the problem explained superbly!

Highlighted
Advocate II
Advocate II

Re: Online service giving errors and not refreshing but desktop version fine

Nothing back from microsoft, but... i a pretty crappy solution, but i was able to make it work. 

 

In order to avoid referencing the columns that are magically put into the report, use the "Remove Other Columns" feature in the Query Editor.  If you select the ABSOLUTE minimum number of columns you are using for your report across ALL data sets synced, (ctrl + shift + click) to select only the columns you are using... and then right click and select remove other columns the steps reference only the used columns.  

 

Thus you get something like this: 

#"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns1",{"Column 1", "Column 2", "Column 3", "Column 3")

 

instead of:

  #"Removed Columns" = Table.RemoveColumns(#"Removed Other Columns",{"ERROR CAUSING COLUMN 1". "ERROR CAUSING COLUMN 2". "ERROR CAUSING COLUMN 3". "ERROR CAUSING COLUMN 4". })

 

Once you remove them with this method, the Web application does not know that the bad columns exsist and completes a full refresh.  

 

It's complete bull**bleep** and i have multiple reports with 5-10 data sources with 30+ columns each.... but it works.  And this is a total work stopper for my org. 

 

Let me know if this works for you or not

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors