Hi ,    i still get confusing , When i visualize between TY and LY the line is not overlapped.  it shown the continous , even i chnge the X to Categoral , it keeps appear like this. I found my past reports look the same but the visualization on these calculation looks fine.  i also get confusing over this , sometimes i get it fix , sometimes i don't . and the calculation i used for last year shown 2019. it should be 2017 , not 2017. i dunn have data in 2019.    ... View more

Hello - I am connecting to a SQL Database, and am select Import for Data Connectivity Mode.   After shaping my data in the query editor, the data source is being switched to DirectQuery mode.  This is then causing an error as I am using transformations that are not supported by DirectQuery.  Clicking the "Switch all tables to import mode" option or switching the data source back to Import with the UI in query editor both have no effect on this.   Has anyone encountered this and identified a solution? ... View more

Hi! i need to create a filter with 3 boxes one should shoe days ,months ,years. And remaining 2 are from and 2 Dropdown boxes.By cliking on days on the first dropdown it should display Days from 1 to 30 in 2 and 3 rd dropdown boxes And same if i select month from first box the 2 and 3 box sholud diaply month names same as by cliking Year it should display Years can we make these type of filter  sample model of filter is ... View more

Hi  I have a price column,product column and date column the price varies for a each product according to date i need to find the max and min value of that product max should come under one column and min should be a column i have tried different DAX formulas i didn't get the output i want PLz help me to sort it out   Thanks in advance ... View more

I have been using Power BI for a while and I have never run into something that it cannot do. I have loaded large amounts of data into it and it has handled it without any problems. However, I am getting the "Memory Error: Memory Allocation Error.Try simplifying or reducting the number of queries." This is on a 64-bit Windows 10 desktop with 8 GB of ram. The memory usage on the box is 4GB while this is running.   There seems to have an interernal limit on the number of relationships that it can handle.   I have 2 tables: Association and Organization.  Organization has about 70k organizations in it and the table is fairly wide with 20 or so columns. Association has about 140k relationships between those businesses and is made up of ParentOrgID, ParentName, and ChildOrgID. The entire model is well under 100 MB. I am just trying to create a relationship between Association.ChildOrgID and Organization.OrgID. That is when the memory error occurs. An organization can belong to many different associations and a single Association can have 8k Organizations.   Tried logging this issue with Microsoft support and they were not able to help.   Error Message: {"changes":[{"relationshipUpdateProperties":{"isActive":false,"referentialIntegrity":false,"fromTableName":"Association","toTableName":"Child Org","fromColumnName":"ParentOrgId","toColumnName":"OrganizationID"}},{"relationshipCreate":{"isActive":true,"referentialIntegrity":false,"fromCardinality":"Many","toCardinality":"One","crossFilteringBehavior":"OneDirection","securityFilteringBehavior":"OneDirection","fromTableName":"Association","toTableName":"Child Org","fromColumnName":"ChildOrgId","toColumnName":"OrganizationID"}},{"relationshipDelete":{"fromTableName":"Association","toTableName":"Child Org","fromColumnName":"ParentOrgId","toColumnName":"OrganizationID"}}],"hasQueryImpact":true} Failed to save modifications to the server. Error returned: 'Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries. '. ... View more

When loading data to the model, Power BI is decoding a "%2f" in the URL to a "/", which must be encoded. See below.   https://[DOMAIN]/[PATH]%2fuser?[QUERY]   I've tried forcing the "/" to be encoded in the M query, which works in the Query Editor using "Uri.EscapeDataString("/"). let Encoded = Uri.EscapeDataString("/"), Source = Json.Document(Web.Contents("https://[DOMAIN]/[PATH]" & Encoded & "user?[QUERY]", [Headers=[Authorization="[AUTHKEY]"]])) in Source This is ignored when loading data to model and I'm received (redacted) the "/" decoded, which is causing the 404 Error.   OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://[DOMAIN]/[PATH]/user?[QUERY]' (404): Not Found.   Unfortunately, the API I'm working with requires this section of the URL to be encoded (I've tested this outside of PBI). I'm able to view and model the data unimpeded in the query editor, but the encoding during the model loading is causing an Error 404.  The forum were very helpful, but nothing apart from a custom Python CSV export is a viable workaround. ... View more

Note the following image.  It is a dashboard with a "pin live page" from a report. The entire live page works, but the button in teh top left (highlighted in red) is a reset button linked to a reset bookmark.  It does not work when pinned to a dashboard. ... View more

This has been an issue for as long as I can remember.  When a user sets a screen resolution to a low level, many of the user dialog boxes do not render on the screen in such a way so the user can click the OK or Cancel Button. I have attached 3 images   Image 1:  Note I cannot see (or click) the OK button in the Get Data dialog Image 2: Note I cannot click any buttons in the "explain the increase" dialog Image 3:  These were my resolution settings. ... View more

Totally absurd situation: changing the data type adds more data to the database? In any case, that is something I would've ever expected..    the other filter is filtering only dates for me, not relevant in this problem.  Is there something wrong I'm doing?  ... View more

Hi,   I am having an issue with DirectQuery on IBM DB2. I am loading one table without any issue but I have just afterwards this message : Couldn't load model schema   Here is the log : *********************************** Feedback Type: Frown (Error) Timestamp: 2018-08-22T07:56:41.8502021Z Local Time: 2018-08-22T09:56:41.8502021+02:00 Session ID: 8bdcec3a-47c5-440f-a84b-669be6a879a5 Release: August 2018 Product Version: 2.61.5192.601 (18.08) (x64) Error Message: Impossible de charger le schéma de modèle. OS Version: Microsoft Windows NT 10.0.16299.0 (x64 fr-FR) CLR Version: 4.7 or later [Release Number = 461308] Peak Virtual Memory: 34.3 GB Private Memory: 589 MB Peak Working Set: 873 MB IE Version: 11.309.16299.0 User ID: ec7af851-81fa-47ad-bd4c-d9ff2f67cb65 Workbook Package Info: 1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: DirectQuery Snapshot Trace Logs: C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\FrownSnapShot1921936986.zip Performance Trace Logs: C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip Enabled Preview Features: PBI_compositeModels PBI_DB2DQ Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_newFromWeb PBI_SpanishLinguisticsEnabled CustomConnectors PBI_variationUIChange PBI_canvasTooltips PBI_PythonSupportEnabled PBI_showIncrementalRefreshPolicy Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 125% Supported Services: Power BI Formulas: section Section1; shared Requête1 = let     Source = DB2.Database("as400chaprod.axereal.dom:446", "S6558D3B", [Implementation="Microsoft", Query="SELECT NTSTIE,#(lf)    NTSCIV,#(lf)    NTSNOM,#(lf)    NTSSER,#(lf)    NTSAD1,#(lf)    NTSAD2,#(lf)    NTSCPO,#(lf)    NTSVIL,#(lf)    NTSCID,#(lf)    NTSNOD,#(lf)    NTSSED,#(lf)    NTSA1D,#(lf)    NTSA2D,#(lf)    NTSCPD,#(lf)    NTSVID,#(lf)    NTSLIR,#(lf)    NTSTEL,#(lf)    NTSPOT,#(lf)    NTSTEA,#(lf)    NTSFAX,#(lf)    NTSTLX,#(lf)    NTSTDO,#(lf)    NTSFTI,#(lf)    NTSADI,#(lf)    NTSDEV,#(lf)    NTSPAY,#(lf)    NTSCOI,#(lf)    NTSSIR,#(lf)    NTSSTJ,#(lf)    NTSTVI,#(lf)    NTSDEN,#(lf)    NTSDSO,#(lf)    NTSMOT,#(lf)    NTSANC,#(lf)    NTSANF,#(lf)    NTSZLI,#(lf)    NTSC01,#(lf)    NTSC02,#(lf)    NTSC03,#(lf)    NTSS01,#(lf)    NTSS02,#(lf)    NTSS03,#(lf)    NTSS04,#(lf)    NTSS05,#(lf)    NTSS06,#(lf)    NTSS07,#(lf)    NTSS08,#(lf)    NTSS09,#(lf)    NTSS10,#(lf)    NTSS11,#(lf)    NTSS12,#(lf)    NTSS13,#(lf)    NTSS14,#(lf)    NTSS15,#(lf)    NTSS16,#(lf)    NTSS17,#(lf)    NTSS18,#(lf)    NTSS19,#(lf)    NTSS20,#(lf)    NTSS21,#(lf)    NTSS22,#(lf)    NTSS23,#(lf)    NTSS24,#(lf)    NTSS25,#(lf)    NTSDTC,#(lf)    NTSDTM,#(lf)    NTSDTS,#(lf)    NTSUSC,#(lf)    NTSUSM#(lf)FROM S6558D3B.IDAFCGEN.TIERSP", CreateNavigationProperties=false]) in     Source; *************************   Thanks for your help,   Gary   ... View more

You might have come across a situation when SQL data which is in milliseconds is shown as below in Power BI desktop as whole number and you want to convert it in Days HH : MM : SS     Please use below query to convert for example "TOP (100) PERCENT dbo.service_req.timer1, FLOOR(dbo.service_req.timer1 / (1000 * 60 * 60 * 24)) AS Timetocloseindays, FLOOR(dbo.service_req.timer1 / (1000 * 60 * 60)) % 24 AS Timetocloseinhours, FLOOR(dbo.service_req.timer1 / (1000 * 60)) % 60 AS Timetocloseinminutes, FLOOR(dbo.service_req.timer2 / (1000 * 60 * 60 * 24)) AS Timetorespondindays, FLOOR(dbo.service_req.timer1 / (1000 * 60 * 60)) % 24 AS Timetorespondininhours, FLOOR(dbo.service_req.timer1 / (1000 * 60)) % 60 AS Timetorespondininminutes" Output will be as below       ... View more

Hi, I am trying to load data from Project Server into Power BI Desktop but keep getting this error message.   Any help would be greatly appreciated: I am using Power BI Desktop (x64) Version 2.61.5192.601 64-bit (August 2018).   Regards,Vanessa     ... View more

      Hi team ,  My purpose is to have condition of High Risk , POS , Normal.  * I have different Categories : Label and Concentrate in the same table.  * You can see the Contrate conditin is  Description  Categories  Min High Risk  Max High Risk  Min Pos  Max Pos Min Normal  Max Normal Concentrate Coca-Cola Part 1 Concentrate -100000000 60 60 80 80 10000000000   * and I have Label condition is :  Description  Categories  Min High Risk  Max High Risk  Min Pos  Max Pos Min Normal  Max Normal LABEL:PLASTIC 350ML DASANI Label 270 10000000 180 270 180 -1000000000   *These 2 categories will be in the same table up and down.  So i use the condition Calculation as per above. But the result is not meet my expectation.  there're blank on the result. Look like the calculation were wrong and not meet.    is there any one know the best practice of such different condition ? Can you tell me how ? Your guidance is much appreciated.  Thanks with Regards,  Chanleakna Hang            ... View more

Hi,   I found the Impala connection is not working in Aug. version PBI Desktop (in fact, it has issue since July version). Below is error message. However, it works in March version with exact same connection. So I believe it should be a bug.   Details: "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (0) Failed to initialize SASL client library: generic failure"   Thanks, MD ... View more

Dear All   I have a data and i made dahsboard for this data and everything okay. now i want to change the column header name for my source data, but still i need to use the same dashboard and same datasource . My data source its big i cant change the name for each one . how to I update PBI so moving forward and use the new header name?   Best Regard     ... View more

hi  , my report shown no data here while the others show YES.  not sure what happen here.  can anyone tell me how to settle this.  ... View more

Hello,   I am currently having two major issues with my Power BI. Currently, I am using a microcontroller to upload sensor data to my OneDrive account in the form of a .csv file. The .csv files are updated every 5 minutes with the latest reading, and at midnight, they are saved to a different folder in my OneDrive with a timestamp, and the contents of the original .csv file are replaced with the newest reading at midnight.   For clarity's sake: temp.csv is updated every 5 minutes in the folder "current data". At 11:55pm, temp.csv will have 288 rows of the following format: "MM/DD/YYYY Hr:Min:Sec, Sensor Location, Unit, #####". At 11:59pm, temp.csv is saved into "archive data" with the timestamp, i.e. "8.16.2018.temp.csv". Then, at 0:00, temp.csv contains 1 row of the previous format, with the newest sensor reading.   My two issues with Power BI are: 1) I have a dashboard to show the "temp.csv" file, as well as the other data files, that is supposed to update hourly as per the "pin a live report" button in the dashboard. It does not update hourly, or even daily. 2) At midnight, I will sometimes lose connection to the dataset. I get the following report:   Activity ID   30566b80-62c9-4cbd-9485-d9fce04dc05b Request ID   469c45f2-038b-a8bc-dee3-da15e3784ea8 Correlation ID    c601ad2b-fdd6-a139-fea2-d730eb872e57 Time   Thu Aug 16 2018 09:10:53 GMT-0700 (Mountain Standard Time) Version   13.0.6289.161 Cluster URI   https://wabi-west-us-redirect.analysis.windows.net   Essentially, I need to know why my dashboard doesn't update hourly like it says it will, and why I lose connection to my dataset when the file still exists under the same name in the same format at the same location. I want to be able to show the day's readings and have a live data up to the soonest possible instance.    Any help would be greatly appreciated. ... View more