Hey everyone! It is my first time here and I hope that someone is able to help with my issue.  I am using Hierarchy Slicer custom visual (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=DetailsAndSupport) for one of my projects and it is not behaving as excpected.  I have added school ownerships and schools into the slicer fields. Everything works fine as long as there is more than one or two schools (leafs) under the ownership (picture below). "munitsipaal" is the ownership and "Emmaste Põhikool" is a school.    Problem starts when there is only 1 or 2 schools as a choice as it is with "Hiiumaa Vabakool" under "eraomand". It just won´t show up in the visual alone! But if I were to choose one from below (from another ownership where there are many) then they both show up in the visual.  I have tried to check my measures and I do not believe it has anything to do with the measures, because exactly the same school shows up in the visual from a normal PowerBI visual while the measure inside the visual is exactly the same.  NB! I ma using disconnected tables to add different schools to the visual. I will add example of the measure below:  Valitud võrldusalused (KOV joonis):= VAR NoLimit =     CALCULATE (         COUNT ( 'TNA_FactTulemusnaitaja'[value] ), TNA_FactTulemusnaitaja[Limit] = 0) VAR Result = CALCULATE (     AVERAGE ( 'TNA_FactTulemusnaitaja'[value] ),     FILTER (         'TNA_FactTulemusnaitaja',         (             'TNA_FactTulemusnaitaja'[AsutusID]                 IN VALUES ( DimKool_Filter1[AsutusID] ) && ISFILTERED ( DimKool_Filter1[NameClean])         )             || (                 'TNA_FactTulemusnaitaja'[AsutusID]                     IN VALUES ( DimKool_Filter2[AsutusID] ) && ISFILTERED ( DimKool_Filter2[Name])                               )             || (                 'TNA_FactTulemusnaitaja'[AsutusID]                     IN VALUES ( DimKool_Filter3[AsutusID] ) && ISFILTERED ( DimKool_Filter3[Name] ) &&  NoLimit             )             || (                 TNA_FactTulemusnaitaja[AsutusID]                     IN VALUES ( DimKool_Filter4[AsutusID] ) && ISFILTERED ( DimKool_Filter4[NameClean])                     )             || (                 TNA_FactTulemusnaitaja[AsutusID]                     IN VALUES ( DimKool_Filter5[AsutusID] ) && ISFILTERED ( DimKool_Filter5[Name]) &&  NoLimit                                                                                 )     ) ) RETURN Result Has anybody an idea why is it doing so? 🙂  Best wishes, Kairi ... View more

Hi, In the chart "Matrix", I putted the filed "user"  on the line Then I added the "sum of prestation invoice" as value 1 and "sum of product invoice" as value 2   I use "Display value as" for the "sum of product invoice" To display total as a %. % of column => it works correcly % to total global => it works correcly % of the line => it's always at 100%. Is there any trouble to correct ?   Thanks by advance.     ... View more

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The underlying connection was closed: An unexpected error occurred on a send."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://api.smartsheet.com/2.0/home?"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Metals Journal. ... View more

One of the dataset based on smartsheet throws an Error Code: “Out of Memory” when try to refresh ... View more

Hi there,   I am trying to connect Power BI to a Python dataset using this code in Get Data import seaborn as sns tips = sns.load_dataset("tips")   However, I'm getting this error.   Details: "ADO.NET: Python script error. <pi>Traceback (most recent call last): File "PythonScriptWrapper.PY", line 4, in <module> import matplotlib.pyplot File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\pyplot.py", line 36, in <module> import matplotlib.colorbar File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\colorbar.py", line 44, in <module> import matplotlib.contour as contour File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\contour.py", line 17, in <module> import matplotlib.text as text File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\text.py", line 16, in <module> from .textpath import TextPath # Unused, but imported by others. File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\textpath.py", line 11, in <module> from matplotlib.mathtext import MathTextParser File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\matplotlib\mathtext.py", line 27, in <module> from PIL import Image File "C:\Users\name\anaconda3\envs\py36\lib\site-packages\PIL\Image.py", line 94, in <module> from . import _imaging as core ImportError: DLL load failed: The specified module could not be found. </pi>" Any suggestions to solve this is appreciated! ... View more

With a particular PBIX file, I am facing the issue wherein it gives me an error message " An error occured while attempting to publish <File Name>. The remote name could not be resolved: 'wabiwusbppbiv2.core.windows.net' ". ... View more

When I set a subscription with the option of adding an image preview, the attachment always has 20px of white space added to the bottom. Why is this? If you set the canvas size to be 1280x720 the output attachment image for the email will be 1280x740. Ah ha, you will think, let me just add 20px to the bottom of my canvas since that's the size of png it wants to make. Imagine your dismay when you see the attachment is now 1280x760 to preserve the bottom 20px of white space. What is the reason behind this behavior?   But then a moment of cleverness, what about changing the vertical alignment to be 'middle' instead of top? Now we get 10px on top and 10px on bottom.    What about 4:3 instead? Same thing. Set it to 700px even, export is going to be 720px.    How do I stop this?  ... View more

Hi  I am trying to design the Power BI dashboar like a Web page to show the report links and images. But, it is restricting to add the images & links only in tiles. Also, the tiles are fixed and I am not able to keep the links/images as my wish. This is really a big disappointment and I am not able to provide a good design in the dashboard for the clients. we have already received this feedback from the clients. I don't even get any reference to modify this.  Let me know when this feature will be available in the Power BI dashboard. Also, there are only a set of colors which i can use in the dashboard. Not sure why such restrictions are applied.  With Best Regards, Lakshminarayanan.P.R. ... View more

I have provided direct viewer access for a Power BI report to a member in my organisation without any row-level security (RLS).   However, access to the report for that member was denied. Error pop-up notifications indicate that this member do not have permission to the underlying asset which uses row-level security (RLS).    (Note: I did not set any RLS for any of the dataset and access worked fine for other members of my organisation.)   Apppreciate if i can get help on this situation. ... View more

This has been onlyissue not been able to resolve in Power BI easily.   I have Published new content in Power BI which i can refresh.   have checked numerous time its cloud data source so not sure why it needs gateway.   Well regarless have created a connection still fails even a     ... View more

I am trying to order the legenda of a piled histogram chart in an order that is different from A->Z Z->A using power bi web app. It seems that custom ordering is possible only on the desktop client, while I would like to do it from the web app. any suggestion? ... View more

I know the DataGateway module (https://www.powershellgallery.com/packages/DataGateway/3000.76.18) is in public preview, but it appears to be impossible to use in the same session as MicrosoftPowerBIMgmt - connecting with Connect-DataGatewayServiceAccount means that other Power BI cmdlets just hang in the console with no ability to cancel the command (ctrl+c). You can connect the Power BI service account before the data gateway service account, but not the other way around, but after doing this, cannot call e.g. Invoke-PowerBIRestMethod.   Repro steps: Open a pwsh.exe session Run the below commands: Connect-DataGatewayServiceAccount Connect-PowerBIServiceAccount ... View more

i have single workspace where i would like to subgroup content in the app to specific user group. i have created multiple audience and added specific security group access to the specific audience tab. Although user is able to see the audience tab, but cannot view the content. If i add security group directly on the workspace as a viewer, there are able to run the reports. But again, as a workspace user the security group can see all the content. So, i am unable to limit access to the specific reports or dashboard.  I found a workaround, to add the security group direct access to the dataset. This resolves the issue. But if there are hundred different reports and access to dataset level needs to be given to specific user group then it can take some man-effort to establish permissions. I do not think this is good practice. If any better resolution can be provided it would help to solve.     ... View more

Issue Summary The drillthrough feature isn't working when a single value is selected in a slicer/filter. Buttons set up with a drillthrough action show the "To drill through, select single data point" message despite the fact that there is only 1 data point selected!   This works for other visuals (e.g., table) but fails for slicers, which is incredibly limiting and frustrating. Desired State When a user slices data or uses a filter in the Filter pane, drillthrough works as designed. ... View more

ID da atividade: 2310bbcb-1bca-47d0-a9bd-295fd21d63a5 Solicitar ID: a37d0dab-4899-193a-b5cc-2fbfbf3e5a3d ID de correlação: 1722c941-2be0-a88d-95a0-a09af29bb5e4 Hora: Wed Dec 21 2022 09:25:09 GMT-0300 (GMT-03:00) Versão do serviço: 13.0.19635.59 Versão do Cliente: 2212.1.11454-train Cluster URI: https://wabi-brazil-south-b-primary-api.analysis.windows.net/ ID da atividade: 2310bbcb-1bca-47d0-a9bd-295fd21d63a5 Solicitar ID: a37d0dab-4899-193a-b5cc-2fbfbf3e5a3d Hora: Wed Dec 21 2022 09:25:09 GMT-0300 (GMT-03:00) Versão do serviço: 13.0.19635.59 Versão do Cliente: 2212.1.11454-train Cluster URI: https://wabi-brazil-south-b-primary-api.analysis.windows.net/ ... View more

I have an app published in Service that is open to the entire organisation. However, several people (who have a Pro Licence) have reported that they get an error message when they try to access it saying that they do not have permissions to the underlying dataset. When I check the dataset (which is stored in a separate workspace) it says that the entire organisation has permissions via the App.   To get round this I give the user in question build access to the dataset, but then immediately remove that access again.  When they then click on the App link it allows them to view it.   This seems like a glitch, but if anyone knows a better way to navigate the issue I'd welcome it.   Thanks   Ben ... View more