Supporto di Power BI

Cerca

Allow user’s cloud data sources to refresh though this gateway cluster box not staying checked

Hi All,   We always had the box checked for “Allow user’s cloud data sources to refresh though this gateway cluster...”.  Now this box will not stay checked, even if I check it and hit ap...

Compress back PBIX files: file corrupt

Hi. Due to the fact that powerBI is not multi-language, I want to translate the labels that appear in the "Layout" file inside the pbix automatically, from a file of type i18n. For example:   ...

Re: Help needed in power query

This one might help you: Cartesian Join of two queries to create ...   Table.ExpandListColumn  

Re: Distinct count active customer by month

Your Table says 'Sum of Amount'. Seems like On Board Sum of PivotTable. I think there is also the possibility of 'Count' instead of 'Sum'. I prefer creating Measure so then you could use my measure...

Re: Free user cannot find app workspace

Hello @richardlhughes, I have a follow up Question. I am consuming data from dynamics 365 to generate Dashboards which will in turn be consumed by users of Dynamics 365 (Embedded as Power BI Da...

Last Seen Visitor formula

Hello Community,   I am trying to detect last seen visitors of my message App, what I do is I take the latest date of my table and substract the latest date the action "REGISTER_LETTER" (send ...

Re: Measures work for Calendar Year but not Academic Year

hi @v-shex-msft    Thank you for your response, this has sorted out the YTD in the academic format. However I still cannot get Previous year or YTD Previous year to work for the academic ...

Re: Can Power BI Desktop speed up on more CPU Core PC?

Hi , the most important thing when loading information is the latency of the ram. I have a server with 48 threads, but it win by loading 2 million records a core i7 6700, because the memory has ...

Relationship between tables

Hi, I have 2 tables one is Cedentes and their entries and the other is Dim Date, when I bring both of the to power bi I manually establesh the relationship between US full date (DimDate) and Ro...

Heat Streams Vertical Scrolling

Heat Streams sometimes does not scroll (vertically) by mouse. Also, is there a way to add vertical scroll button if data won't fit inside the frame? Thanks.

Re: IF and SWITCH is not working

Yes, worked very well! Now I know how to use the IF statement.   Nice line of thought, I gonna use this last suggestion!   Thanks a lot! Daniel

Re: Service providers - need one, pls recommend

Hi, @twilliams!   Thanks for posting!    As a workaround, you could try signing up for a trial O365 account: https://docs.microsoft.com/en-us/power-bi/service-admin-s...

Average quarterly data by month

Hi,   I been asking around for hlep on this issue in the past fews days but couldn't get a solution.    Below is the powerbi pbix file download link.  https://fere.me/yaup/jb...

Re: Chart with todays date as start date

Hi @Seb2441,   You could try different ways below to what get you want .   1. You could have a Between Slicer started with the date of today.   2. You could create a c...

Re: Change of financial year

HI @Sabi   Try adding a column to your table that groups all rows with values between Apr 17 and Mar 18 with the same value (eg. "FY 17") then use the new column in a filter or axis

Expression that yields variant data type with IF statement?

I used an if statement for a calculated column with no problem if my TRUE variable was fixed example: IsInventry = if(LComment[FileNo]=7,"True",""   If I use a variable as the ...

Initials in icon for Workspace are wrong on Power BI Service

In the Power BI Service, each Workspace has its own circular icon which is made up of the first letters of each word.   I have found that once the intial workspace was created (E.g. with the n...

multi distinct columns into flat format

I manged to combined multiple CSV into one, but the flatening using transpose/pivot/unpivot combinations is not working (well) for me. The headings that I want are: 'country', 'month', 'year', 'quant...

View On premise gateway setting window from the server

Hi Guys,               The On-premise gateway was installed in a Server using credentials of a service account. Now I got access to the server, but when I click on...

MAX help

Hello Community.    I have a table like this   Shares Date 1 01/02/2003 2 02/02/2003 4 03/02/2003 5 04/02/2003 3 05/02/2003 47 06/02/2003 1 07/02/20...

Re: Specific group date ranges

HI @Theasianmenace,   >>As you see it goes in increments of five, but then by 15 as the time progresses. I'd like to be able to customize that range on a single slicer. Is th...

Visual Level Filters

Hello,   When I change a filter in Visual Level Filters and I republish, it doesn't take into account the changes in the app. I don't undrestand why!   Thank you for your help

Re: Power bi direct query with windows authentication, how to setup

Any news with updated version on this old subejct ?

Unable to start Power BI Desktop. Could not load file or assembly

  I am unable to open my Power BI Desktop. Instead of booting up, the error below pops up. I am unsure how to proceed. Please help. Thank you.   I am currently using the March 2018 versio...

Re: Conditional Lookup (Match ID and dates and fetch correct salary)

Amazing! It worked!!   If you have time to go through the formula and how it works I'd really appriciate that.   Many thanks!!