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!!