Power BI Support

Search

Re: 'Daily' Deferred Revenue Model

Hi, I am interested in the solution you ended up with. Can you please share? 

Calculate duration between a list of times in Report View Table

Hi,    I have the following list of times. How can I calculate the duration this set of times adds up to? There is a time gap from 12 pm - 2 pm which prevents me from doing a simple MAX t...

Error trying to use connector "Hive LLAP" from Power Bi Desktop

We are trying to use "Hive LLAP" connector from Power Bi Desktop, to connect to Hive Cloudera dataset. And we have been trying different types of servers and ports, but only keep getting errors. &n...

Re: report server 2023 jan version not support export data with current layout?

Some of the capabilities in the Power BI service utilize other cloud services to get things done so they are not feasable for them to port to an on-prem environment. If you have the need for specific...

Re: Refresh Report with Service Principle

Hey did you manage to get this sorted? I am busy going down the same route - especially since my user account requires a PIM which only lasts 9 hours 

Re: DataSource.Error: Web.Contents failed to get contents from Sharepoint

Recent refreshes between SharePoint and Power BI seem to be successful.

Re: Revenue Count Deduplication

Hi, Sally's answer should be 6,750.  You may download my PBI file from here. Hope this helps.

Re: Cómo crear una tabla de resumen o matriz para una combinación de valores diferente desde la misma columna

@ymc , Por favor, intente: Primero cree estas medidas: Event_1 = CALCULATE(MAX('Table'[Event]),FILTER('Table',[Event]="E1")) Hour_1 = CALCULATE(SUM('Table'[Hour]),FILTER('Table',[Event]="...

Re: Power BI Desktop - Publish doesnt work - Status changed to: Investigating

Hi @RémyA  Can you publish your report to Service normally now ? I tested with May version , publishing report to Service worked well , you can see the screen below . Maybe you can uninst...

Despivotar / Combinar columnas

Hola, chicos. Tengo un archivo de Excel que estoy intentando extraer en Power BI. El archivo tiene una serie de columnas "Combinadas" en Excel: Me gustaría una sola columna para fechas, una s...

Re: How to make date columns filterable

I‘m sorry,I don't understand "make sure that you include these fixed years in your year filter" mean,The table is a trader order,like this, the year filter is date hierarchy, The other...

Re: Columnas de inventario inicial y final

Hola Comparta el enlace de descarga del archivo PBI. Asegúrese de que haya una tabla de calendario con una columna de inicio de semana.

Re: Pinned Tiles is not showing correctly to the dashboard in Microsoft Power BI Desktop App

Hi @ymalik  This may be due to the page in Power BI Desktop showing "fit to page", so there is a gap, you can try setting page to 'actual size'.   Best Regards! Yolo Zhu ...

Re: Dataset || Data Gateway Configuration In Power BI Service

Hi @powerbi-enginee , You could use your Power BI administrator account to configure the gateway, and after successful configuration, you could share the gateway with your developers and ...

Re: DateDiff Array with a Many to Many join

Hi, Share a few more rows in the 2 tables, explain your methodology and show the expected end result.  You may do so in an MS Excel file.  I'll understand your logic from there and transl...

Re: line chart with two slicers of custom dates and two date tables

@mgtulips , if you have these dates you can have 2 lines, not one overlapping.   Both need to independent Date table slicer and you can have two measures like   //Date1 is independ...

Re: Comparar 2 pero categorías

@Syndicate_Admin , consulte si este enfoque puede ayudar Comparar datos categóricos usando segmentaciones de datos: compare dos marcas: https://youtu.be/exN4nTewgbc

Re: Unpivot / Merge Columns

Can you please share your demo input and expected output!

Re: Or condition using slicers (one column)

Hi, @majo23  According to your description, I don't quite understand the purpose of creating so many slicers. Do you want to choose two slicers to control whether this row contains o...

Re: Unpivot / Merge Columns

the best way to do this is in Power Query Editor

Re: Color change for specific text in card visual

Hi @Composed_MS  When faced with these situations, I tend to reach for a simple solution that just works. Uses a text box to combine two cards and apply conditional formatting rules. As ...

Re: Getting new Report Builder 401 error.` Report Builder Hell

Any fix on this @Criamon ? on the same boat too

Re: Group columns from a different tables, filter it and have SUM of values in the end

@Pulyk , Consider measures   Compliance Type= if(Sum(Fact[VOlumn 9L](>0, "In Compliance", "Out of Compliance")   Count of Compliance = Countx(FIlter(Summarize(Fact, Store[Corp...

Re: Connecting Oracle to Microsoft fabrics

@wahmed20 - Thanks for the question and using Fabric Community. Microsoft Fabric supports many on-premises and cloud data sources, and each source has its own requirements. To learn how to ad...