Поддержка по Power BI

Поиск

DATA MODELLING

How to learn data modelling for power BI ?

Re: Power BI Pro Embedded View on Mobile - Tabs not showing

Hi,   I have answered your questions below.   1 - From within Power BI Desktop we publish to web 2 - Both, ive tested on iPhone 6s+ and Samsung S9+ and get same issues 3 - Within brow...

Re: Doubts with INNERJOINs and lineage

@Zubair_Muhammad   And since you like tough questions I have something else regarding the same article on SQLBI. (Disclaimer: I have posted this question there as well, in case you pr...

what are the limitations of sybase, IBM's, postgresql with power bi?

Hi all, I need some information like what are the limitations of sybase, postgresql and IBM DB2 database when connected in power bi *(when used in power bi). can you any please reply on this with ref...

Re: Today compared to same day last year

Hi @LisaB,   Have you solved your problem?   If you have solved, please always accept the replies making sense as solution to your question so that people who may have the...

Re: Calculate login count

@alexsimonsson,   To be general, you may refer to steps below:   1. Create a calculate column to achieve the month: Month = MONTH ( Table[created_at] ) 2. Create a slicer based...

Re: Filters not Rendering in Power BI Service

@Jswedberg @jeckste, Please download  Feb release of Power BI Desktop( 2.66.5376.1681 ), and check if the issue still occurs after publishing report from this version of Power BI Deskto...

Re: how to create a measure with conditional values

Hi @saritart1,   Please try this:   New Measure = IF ( SELECTEDVALUE ( table1[Medida] ) = "Baja"; SUMX ( ALLEXCEPT ( asistencia; asistencia[Nombre]; asistencia[...

Re: Query editor bug: list may be incomplete

If I don't use RLS, then yes, I do see the full list of companies. However, if I use RLS, I get empty reports cause RLS is established to see companies 5-8, and they are not 'unhided' from the query ...

Re: Slicer to Filter Data Specific Data

Hi @atul9063,   Please refer to below steps to achieve your requirement.   Steps: 1. Create a new table with all metric types and use new table column as source of slicer. ...

How to embed Power BI report in NAV 2016

We have created Power BI reports based on NAV 2016. Now would like to access these reports and dashboards  from NAV 2016 itself. How can we achieve this?    Regards  Vrush...

Re: RANKX issue: dynamic index column with multiple filters

I just added the filters in an ALLEXPECT and now it works perfectly - thank you so much!

Power BI Desktop November 2018 was the last version that would work on my PC

I use 64bit versions and the December 2018 and February 2019 crash during the app startup  "We are unable to render..." Perhaps there have been changes in the I/O.

Re: excel dataflow filepath setup issue

Hi there Yes I totally forgot because dataflows are a cloud based service, if you are connecting to any file that is not cloud sourced, you would need the Gateway to connect to the file.

Power BI Newbie - Dax Formula Help

Hi,   I have two tables with a collumn in each in which i need to pull a value from the first table and collumn, if a particular value is present then present this in a new collumn (do not ref...

Re: Does not publish but says published successfully

Don't get how could that be the issue. As I have deleted a visual and put a completely different one on that location and once I publish it neither the old visual is deleted neither the new one added.

Re: Does not publish but says published successfully

The data is not the problem, it updates the data.   It does not update the visuals. I have changed the design of old visuals and added new visuals. When I publish it nothing changes on what re...

How to display Traffic Flow on Maps

->Case : I have around 1 melon records like following:  [ID],[longitude],[latitude],[Time]  Attached_sources those are all cars has been located in two streets on same city during...

Re: MIGRATE MEASURE TO CALCULATED COLUMN

Right, in a column context ALLSELECTED means your current row. Change that to ALL instead.

Need a Max dax formula

Hello, I need the latest date in "Max Date" column, for a A-E in "Site" column which is "Fully" in "Status" column. In Excel I used IF & MAXIFS. Thanks   Site Date Status Max...

Slicer changed after clicking on bookmark

background: I have a visual which I default to Quarter "FY19-Q3"... Image1.. After clicking on the bookmark, you will see that the Quarter = "FY19-Q2" Image2 I dont want the slicer to change. Kindl...

Report is auto trimming text

Hi,   I am new to Power BI and have been trying to get a P&L statement report created.  The data I receive is already grouped in the accounts, I just need to display them in a meaning...

Re: Does not publish but says published successfully

Yes I have double checked. I am publishing it to the correct workspace

Re: "This table is empty" - Shows Headers but No Rows

Hi @Jaf017,   While the loaded table from DB2 shows empty in desktop, click the refresh button to see if it works. Besides, you could break the SQL Query into two, so that you load the ...

Re: calculate account gp

@yelsherif   on the example i put just 2 companies but i got more than 50 soi need measure to calculate for each company, making a measure for each company its not gonna work