Forum Discussion
The 'HasUniqueRoleAssignments' column does not exist in the rowset.
- 9 years ago
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
Good Morning! I downloaded the desktop version that was released yesterday and at first glance, the issue seems to be resolved!
- mzikra9 years ago
Advocate II
Testing right now and all looks good. Release of version 2.46.4732.721 on May 15 seems to solve the problem. But this release seems to be breaking some formulas that i was using. I've lost 4 visuals in one report. Hooray...
https://www.microsoft.com/en-us/download/details.aspx?id=45331
- boujin9 years ago
Advocate I
Big shoutout to sanjay4reddy and mzikra for flagging this. I was banging my head against a wall for hours trying to figure out how in the world Power BI Desktop and the Service could produce two different results from a data refresh. I've got a complex dataset and had very little clue as to where the error was coming from because the error in the data refresh in the PBI Service doesn't mention which tables the error is coming from. Through a lot of trial and error I started to narrow things down to the tables that were connected to SharePoint and then came across this thread. Installing the latest version of Power BI Desktop now shows me the same refresh errors that I'm seeing in the service and makes it possible to troubleshoot again. Ugh. That wasn't fun.
- sanjay4reddy9 years agoFrequent Visitor
Glad this was useful to you buddy :)
- mzikra9 years ago
Advocate II
It looks like this release somehow has reset a lot of of my querie fields to "text" from being decimal or percentage.
Resetting those fields back to decimal solved the problem. Curious if that happened to anyone else
- sanjay4reddy9 years agoFrequent Visitor
mzikraI hate when 1 things fixes but another breaks...