Hello   When i try to rename a table in the query editor, PBI freezes. I suspect it comes while afterwards i am summarizing tables in DAX. I am using the latest Version: 2.66.5376.1681 64-bit (Februar 2019)   The steps: 1 in the query editor i right click to rename the table (no special character).  2 i validate the new name (Enter) 3 Close % apply 4 Get the error message below    Why this error? How to avoid it? BR, G. ... View more

I have updated a report I am working on and republished it this morning. The dataset has been sucessfully updated and refreshed, but the report itself (I added some tabs and changed some visuals) did not. Almost all of my report visuals say they need to be fixed in the online version. The file works fine in the Desktop version. If I download the file from online, it shows me the old version. I have been waiting for this to fix itself for 6 hours and am convinced I have done something wrong on my side. I reinstalled Power BI to the latest version this morning which has not fixed the issue. Am I missing something? ... View more

Hi,    I am trying to apply RLS on a report in Power BI Report Server with Publisher permissions, but I can not find the option "Row-level security". This option appears only for users who have Content Manager permissions. Considering the documentation at https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server (where you can read "If you are using the default permissions on the Power BI Report Server, any user with Publisher or Content Manager permissions to the Power BI report can assign members to roles for that report.") it would be possible for a Publisher assign members to a report. Can you please help?   Thank you in advance. Ana ... View more

I've attempted with different Power BI tenants as well as Google Analytics accounts and cannot successfully authenticate when attempting to create a data flow using Google Analytics. This is supposed to be supported per these links:   https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/ https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources   Here is a screenshot of the error I am currently receiving (a pop up window appears momentarily to attempt to authenticate, then dissappears before rendering the error you see). Yes, my pop up blocker is turned off.       This is the supported M query that works just fine in PBI desktop: let Source = GoogleAnalytics.Accounts(), #"23715579" = Source{[Id="23715579"]}[Data], #"UA-23715579-1" = #"23715579"{[Id="UA-23715579-1"]}[Data], #"46652768" = #"UA-23715579-1"{[Id="46652768"]}[Data], #"Added Items" = Cube.Transform(#"46652768", { {Cube.AddAndExpandDimensionColumn, "ga:exitPagePath", {"ga:exitPagePath"}, {"Exit Page"}}, {Cube.AddAndExpandDimensionColumn, "ga:hostname", {"ga:hostname"}, {"Hostname"}}, {Cube.AddAndExpandDimensionColumn, "ga:landingPagePath", {"ga:landingPagePath"}, {"Landing Page"}}, {Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}}, {Cube.AddMeasureColumn, "% Exit", "ga:exitRate"}, {Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"}, {Cube.AddMeasureColumn, "Entrances", "ga:entrances"}, {Cube.AddMeasureColumn, "Entrances / Pageviews", "ga:entranceRate"}, {Cube.AddMeasureColumn, "Exits", "ga:exits"}, {Cube.AddMeasureColumn, "Page Value", "ga:pageValue"}, {Cube.AddMeasureColumn, "Pages / Session", "ga:pageviewsPerSession"}, {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"}, {Cube.AddMeasureColumn, "Time on Page", "ga:timeOnPage"}, {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"} }) in #"Added Items" It doesn't seem to matter which query I attempt to use, same error anyways.   I have attempted to setup the data flow on both the North Central US (Illinois) and the Southeast Asia (Singapore) tenants.   ... View more

We recently updated our Power BI Desktop version and our color picker capabilities stopped working properly.   On the Desktop software, when you pick a color, it briefly shows that color then jumps to gray.   If I edit the report on the app.powerbi.com website, the color holds and works normally.   We have so many reports using this visual, it would be a pain to have to edit all of them after publishing.   Any ideas? ... View more

Here is the image https://www.dropbox.com/s/rygkrkukzisvvj4/Screenshot%202019-01-17%2015.10.03.png?dl=0 ... View more

I am using samle from App Owns Data sample https://github.com/Microsoft/PowerBI-Developer-Samples   When I run the application, I am getting error: Method not found: 'Void Microsoft.PowerBI.Api.V2.PowerBIClient..ctor(System.Uri, Microsoft.Rest.ServiceClientCredentials, System.Net.Http.DelegatingHandler[])'.   I tried to resolve it by using solution provided at below link but I am still egtiing the same issue. I am using Visual studio 2017 https://community.powerbi.com/t5/Developer/Method-not-found-Void-Microsoft-PowerBI-Api-V1-PowerBIClient/m-p/129466/highlight/true#M4468 ... View more

Multiple Users from my Organization has reported the error on schedule refresh since yesterday. Below is the error which everyone is getting. Is there any service issue ?? I see in support page there is an issue with North europe users but error message mentioned there is different. Microsoft any comment?? atakildefeilThe operation was throttled by Power BI Premium because there were too many datasets being processed concurrently. Please try again later. Klynge-URIWABI-NORTH-EUROPE-redirect.analysis.windows.net Aktivitets-ID3d2fa8e2-9208-4225-a377-04a6d9962221 Forespørsels-ID85a06e5f-7f2a-d462-0867-429f82ffbc77 Klokkeslett2018-12-19 09:54:25Z ... View more

We are using the new Filter Feature. On Power BI Desktop will have a report filter set to International. We have the report filter locked and set to not show. We want our report tabs to automatically be filter by this value and want to prevent users from changing the International filter. When we publish to Workspace, the International filter work as expected. The filter is hidden and locked on International. The user can use the other filters.   However, when the same report is viewd on an Iphone or an Android phone, the hidden and locked filter is available. Users can change and see the hidden and locked filter. The report filter do not behave the same on the phone as it does online.           ... View more

Hi,   I'm working on a model that needs to have two layers of restriction.   I can't do both at the same time because it is applied on a model that is used for several reports, and not all of them need the over-restriction to take place.   The first layer is based on the business unit that a user has been assigned to, in CRM (D365), and defined as a dynamic RLS in a role. The hierarchy that these business units describe for this customer has 6 levels. This part is working ok. Let's call this table "A".   The second layer is an over-restriction on top of the first one, with the purpose to allow the users to access just some of the lowest level items in the business unit hierarchy. It's defined with two tables: The first table ("B1"), has two columns, the first column being a user names list and the second column describing whether the user has access to all lowest level business units within their assigned business unit, or not. The second table ("B2") has two columns as well, the first one contains user names again and the second column holds an entry for each of the lowest level business units to which the user has access. The way it is intended to work, is to set a column in table A, determining for each entry whether it's visible or not to the user, and it is applied as a filter at report level, "IsVisible = Yes".   It all would be easy peasy if i were allowed to use the function USERPRINCIPALNAME() in that column. But i'm not, so i've had to get creative...   In order to ascertain whether a lowest level business unit is visible or not for a given user, i have set RLS to restrict the entries of the tables for the second layer of restriction (B1, B2), to those that are explicitly related to the user that is accessing the model.   This part works fine as well, and if i test the solution by switching to a user who has restrictions, i'm able to see the effect of RLS because there's just one entry in table B1, and the list of allowed business units for that user on table B2.   Now, here's where i found the incoherence. I need to use a formula such as FIRSTNONBLANK() in a column in table A, to resolve if the current user accessing the report has any additional restriction according to the content of B1, and in case there is, which are the allowed items listed in B2.   As i've applied RLS to the tables B1 and B2, only one value should be available to be returned for FIRSTNONBLANK(), and that should be for the current user.   But FIRSTNONBLANK() and MIN(), are returning the first real value of the table before RLS has been applied, which does not match to the actual user accessing the report.   How can this be possible?   I am certainly lost, and in a hurry to get this solved.   Thanks in advance for any hint you can provide.   ... View more