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
I am having the same issue.
| Data source error: | The 'HasUniqueRoleAssignments' column does not exist in the rowset. |
| Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
| Activity ID: | 0164ac61-3ef9-4bc7-a0d7-fa026fa6b284 |
| Request ID: | 628b6cc2-29bf-26a9-7473-e0b166b42c36 |
| Time: | 2017-05-12 11:26:24Z |
When launched in Power BI desktop, there is no issue refreshing that data.
Anonymous: The details are basically within my first post. However, this screenshot can provide more clarity on the error I'm facing. Thank you mlamantia for the screenshot.
- mzikra9 years agoAdvocate II
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..
- sanjay4reddy9 years agoFrequent Visitor
mzikraJust tried uploading the report through the "Get Data" options. I still receive the same error when trying to refresh. Do you know if Microsoft has offered any documentation that this is a Known Issue?
- mzikra9 years agoAdvocate II
I've been unable to reach them over the weekend on this ticket. As of now, i have not seen any official notification that it is a known issue, however there is a patch being released on 5/15 (US). I am curious to see if this will fix this issue.
I should be hearing more on Monday for sure
- mattminor9 years agoRegular Visitor
Same issue with me - look forward to the fix. Thanks for chasing Mzikra!