Power BI Support
Search
CONNECTION FAILURE
I really need help, i cant even open my power bi, whenever i try opening it it brings me to the interface of connection failure, ensure the server is running.
Re: Cannot Create New Connection. Timeout expired. The timeout period elapsed prior to....
We are using TNSNAMES.ORA. All setups are the same.
Dual x axes chart with overlapping values
Hi All, I want to create a cluster chart with a trend line whose x axes might have overlapping values viz,(init date,rev date).The x axis values ideally looks like Apr'23,May'23 and so on.How to do ...
Re: Average Per Store on Weekly Data
Table 1: StoreNo Store Name 22 HHH 23 TTT 32 NNN 43 BBB 44 CCC 45 OOO Table 2: StoreNo Store Name Percentage TxnDt 22 HHH 10% 17-10...
Re: How To Create A Measure That is Group And Ignores Filters
I am having issues making this work because "Moves" is a measure and it won't allow me to pull it into SUMMARIZECOLUMNS. That measure already gets the average moves per day as a whole, i do not need ...
Re: I can't get the value of an interaction selection
I figured it out! The default of my card was "no interaction." Once I changed it to filter, it worked. Thank you!
Re: Unable to edit downloaded pbix file which was published through deployment pipeline
Hi @aj1973 , I am able to download from all stages but unable to make changes in the donloaded copy. In 1st deployment pipeline mentioned above(which has 3 stages), I am abl...
Conditional formatting all values using text condition
I am trying to do a conditional formatting, but it looks like because of the summarization, it only formats the first value. See condition below. How can I fix that?
Re: Convert Eastings and Northings to Lat Long in Power Query
Thanks for providing this. It helped me start down my own little journey to convert state plane coordinates to lat/lon. Here's a couple of functions that work in Power Query - the first for lat, the ...
Re: I can't get the value of an interaction selection
@Greg_Deckler Thanks for your help! Unfortunately, I get the same result. The expression is not picking up the fact that I've made a selection. Is there a setting I need to check?
Re: DataSource.Error message
If you step up through your applied steps and find the first step that gets the error, you can likely update the the step to remove the reference to this field. There may have been a change on the so...
Re: Display SharePoint pictures in PBI Report on PBI Service
We are having a similar issue. This doesn't seem to be limited to PowerBI but any request from a different domain to retrieve a sharepoint-tenant hosted image. (We first noticed this when our PowerAp...
Re: DAX help needed
Hi @lbendlin , I have tried but it looks messy again can you open the excel file below ? https://drive.google.com/file/d/1w7YQPyczBTFPcszM8je4aAefhzNiarri/view?usp=drive_link
Re: Filter a query based on a another table
Hi @AnaBraganca , I create two tables as you mentioned, their names are Existencia and Analise. Then I create a new table and it satisfies your requirements. Table...
Re: Count Rows from Table VISUAL
Hi, Write these measures Total = sum(Data[Usage]) Count = countrows(filter(values(Data[Name]),[Total]=0)) Select Nov, Dec, Jan in the slicer/filter. Hope this helps.
A cross table complex condition
Hi Experts! I have two tables, one containing the monthly incentive amount for each store counter, and the other containing the sales personnel for each store counter and whether they h...
Date slicer not updating Avg time
Hi All, I have below tables connected with each other I want to show, number of W Queries and Avg Time W queries column for each employee. number of W queries & Avg time W queries are comi...
3 in a row - consecutive monthly total greater than n value
Need a help on this measure to show each ID - 3 in a row - consecutive monthly total greater than value find the below example data (summarized table with 3 columns) Ex: n=15 ...
Re: Boolean converted to Integer on refresh in Service
This still appears to be an issue today. I have experienced exactly the same behaviour as OP on multiple reports, does anyone have a fix/workaround?
Re: Running Forecast based on Actual data
Hi @KristyP , You can try below formula: avg_ = VAR monthdifference = DATEDIFF ( UsageData[2022 Read date], UsageData[2023 Read Date], MONTH ) RETURN DIVIDE ( U...
Re: Paginated Report Help - Background Conditional Formatting
What about: IIF(Left(Fields!humm2.Value, 1) = "<") OR IsNothing(Fields!humm2.Value) OR Fields!humm2.Value = "", "White", "Yellow")
Re: DAX help needed
well I have got performance issue and I have checked that article as well, but when i change it to addcolumns it is returning different value, so I want to optimize the query.
Re: % RT Broken up by multiple fields
Hi, Based on the table that you have shared, show the expected result very clearly.
Re: Fabric Lakehouse vs SQL Analytics endpoint
This now been resolved by Microsoft Fabric product team. In SQL Analytics endpoint you can refresh tables.
Refreshing the data source from dashboard
I need to have a refresh button on the report so that user can refresh the report when they want. I can create an automate button that can refresh the report but I need to refresh the data source as...