query Discussions

About 849 results - Page 1 of 85
  • Issue#640792: DATEDIFF_BIG Azure DW Direct Query

    Hi,I have used DATEDIFF and I think it is getting translated to DATEDIFF_BIG on backend and there it is giving error that function is not recognised.As per online docs function is available in SQL Azure DW so not sure why the error. It is a direct query connection to SQL Azure DW. Thanks,Dilkush...

  • Issue#716618: Query Parameter Testing

    I am testing query parameters.  I have a Web URL that is constructed of 4 parameters.  Two of the parameters contain multiple values that I want to iterate over using the same base URL parameters. Any thoughts on how I would iterate through the values of the 'Season' and the 'Page' parameters and create a table that was appended for all values where the parameters changed? Here is the script:let Source = Web.Page(Web.Contents(BaseURL & Season & MidURL & Page &...

  • Issue#754789: How to use Query Time Join with Lucene 5.3.0?

    I am referring this link for usage of query time join and I am able to use following method createJoinQuery(String fromField, boolean multipleValuesPerDocument, String toField, Query fromQuery, IndexSearcher fromSearcher, ScoreMode scoreMode) Parameters: fromField - The from field to join from multipleValuesPerDocument - Whether the from field has multiple terms per document toField - The to field to join to fromQuery - The query to match documents on the from side fromSearcher - ...

  • Issue#819643: Incorrect syntax in Power BI - but query works fine in SSMS?

    Hi,I'm getting this error when trying to use a direct query ï»¿But when I run my proc in SSMS it is just fine - I can't figure out why POwer BI doesn't like it. Here's the statement I am trying to use: DECLARE @CLAIMS int DECLARE @from_date_entered date DECLARE @to_date_entered date ---------------------------- SET @from_date_entered = GETDATE() SET @to_date_entered = GETDATE() --SET @from_date_entered = N'03/16/2016' --SET @to_date_entered = N'03/16/2016' ---------------------...

  • Issue#875892: New Phone WhatsApp Query

    -If you get a new phone, and use your existing sim (with the same number) in the new phone then no one will be able to access your old WhatsApps or media from the old phone? -If you get a new phone with a new sim with the same number as your old phone, then no one will be able to access your WhatsApps or media from the old phone? -If you get a new phone with a new sim and new number, but the old phone hasn't been used for 45 days, then all WhatsApp conversations and media will be deleted? Als...

  • Issue#951687: Need Help On Power Query Code

    Can somebody help me with the Power Query code by which I can update the value for Column Spend for against ProductTitle Diff whose formula is Base = 1 – SUM(Spend). Data may increase and pattern is shown below. The source is SharePoint list. I will have to show this data on Donut chart in Power BI. Spend   ReportDate    ProductTitle                  Spend    &...

  • Issue#147199: Copy a Query from one PowerBI file to another

    Does anyone know how (if it is possible) to copy a query from one PowerBI file to another. I have a query that pulls data from CRM (Account Set) that I have customized (i.e. modified values, data types, calculated columns, etc.) that I would like to copy into a different powerBI file instead of having to redo the same query.  ...

  • Issue#325799: Tableau - Is there a way to avoid Tableau from including unnecessary fields from query (Live Conn. S

    Hi, This is my first question - but I would like to thank everyone contributing to this forum for all their work which has helped me a lot! I am working on a live connection to our data warehouser DB, which is SQL Server 2012. I have a simple viz (bar chart) and a parameter control where I can select one of tre different measures I want to display in the viz. The measure-field in the viz is calculated by a formula:     case ParamMeasure    &...

  • Issue#387593: Retrieve query point coordonate to create a plane passing through this point.

    Hi everyone, I am creating a script in shell to modify a command journal from ensight. The goal is simple, i have created "bricks" of Ensight ' journals that i modify in order to change its display. example __________________________ ADD_CASE case: create_viewport ON case: apply_context OFF case: reflect_model_in 'none' # "case: add Case X" flag__casenum #"case: select Case X" flag__caseselect part: select_default part: modify_begin part: elt_representati...

  • Issue#463514: Autodesk - Query Civil 3D Objects?

    Hi, Map 3D & C3D 2016 on Win7 machine. Is it possible to query the data from Civil 3D objects using Map? I'm primarily interested in extracting the data from pipe networks so that each object can be added to our GIS as seamlessly as possible. If a query won'r do it, are there other methods of doing this? I don't care if the objects relate to each other anymore. I simply want each one treated as a point or line feature with attributes defined by the Civil 3D data - so that a GI...

  • Issue#526559: Dell - MD3460 SMART DATA Query - Critical Error

    Desc=Drive error during SMART data query - Unknown error (5h/24h/0h): (adapter=Dell 12Gbps HBA, adapterWwn=Dell 12Gbps HBA, Drive Target Port Wwn=500a0986359ef010)....

  • Issue#966536: Box - Search query does not work

    Hi, I am using Box Java SDK to integrate box api with my application.I need to extract files satisfying certain attributes I specify in metadata.I am using boxfolder.search() .I gives me the resultant files but if suppose I upload a new file and trigger search query,the new file is not amongs my resultant files.It takes time to reflect it.Is this some issue regarding Box API?...

  • Issue#1016056: How to split columns in Direct Query(source is azure sql database)

    How can I split columns in Direct Query. I am not able to use import because my data is too huge. I have a column that has concatenated details(like a.b.c). I want to split it up into 3 columns, so that I can use the Heirarchy slicer.  I have 2 tables. One has less data(fact table) and the other is very huge(dimension table). I need to split the column on the fact table so when I get data from only that table i can do an import and split the column, but wh...

  • Issue#1054520: BT: Speed Frustration Query

    Moved from BT ADSL to Infinity 1 5 weeks ago.BT stated that I would get a guaranteed minimum download  speed of 29Mb/Sec.I never achieved this download figure, using the BT Wholesale checker with results averaging 26.4Mb/Sec with a maximum achievable of 27.38Mb/Sec.I have a wired connection, using HUB 6, but not from the Master Socket.BT sent Engineer yesterday & he reconfigured the wiring so that the Socket I'm using became the Master.On completion the speeds on BT Wholesale check...

  • Issue#1090815: Lenovo - Feedback & a query regarding advanced search

    Hi   Lenovo support team, I found some problems in couple of support pages. These pages can be improved for better user support.  For details,  please refer to my thread  at BIOS-updater-app-not-working.  Additionally, i am not able to get the use of  "numbered list"  icon that appears while i am typing a message to post. For details, again refer to the accepted solution in the above thread i mentioned.  I am using  Safari browser on a Macbo...

  • Issue#1134450: Corsair - 750D airflow scrathed panel/warranty query.

    Sorry, if this isn't the right section, but I have a case warranty query. I recently bought a 750D airflow and built it yesterday. After putting the system together and taking off the protective plastic from the front, I noticed there is scratch on the lower vented panel (a small scratch, but enough that it shines silver and is noticeable) and one of the 5.25" blanking plates is scuffed. Neither were noticible with the protective plastic on. So I'm just wondering if I contact support with...

  • Issue#1188748: BT Business Hub 3 DHCP query

    I need to configure a BT Business Hub 3 with a static address and DHCP range which is different from the defaults available. This is fine, however I am unable to see an option to set the gateway and dns addresses used by the DHCP clients. Is anyone able to point me in the right direction ?...

  • Issue#143: Sony - Faulty A6000 and lens software update query

    My 7 month old A6000 using the original SELP1650 and later purchased SEL55210 has developed a problem. Using the auto modes everything works correctly, but useing A,S or P modes has suddenly produced heavy vignetting and erratic, often under exposure. It would appear to be faulty. I decided to see how updated my lens software was in case an update might cure the problem. The lens status is:- SELP1650 Body V2.00 Lens V.01SEL55210 Body V2.00 Lens V.02 Refering to "ILCE-6000 Support ...

  • Issue#215957: SAN Health related query

    Hi,I am collecting SAN health report from Broacde SAN switches in that one of the fabric has total 9 switches but while adding in to the switch in the Set file, SAN health tool is gathering only 8 switches  not the 9th one, but in switches with the "fabricshow" command it is shows all 9 switches, please help me why it is happening like this and which is not founded 9th switch if iam adding in the set file it is showing separate fabric  ...

  • Issue#263249: PowerShell Query to get Security Group's name and email address?

    I was wondering if someone could help me with a task I've been assigned. We have several types of employees in my company, the biggest being FTE. I was tasked to get all full time employee's name and email address to be able to export it to a .txt document. I have a script to be able to get all AD users, but that list is too big. Can anyone help me with just getting a query for PowerShell that would just get me names and email addresses of users in a certain security group?  Thank you in advan...

  • Issue#66739: Linq query not working as expected.

    Hello All, I have three tables in my database ,  1.Horse 2.Show 3.ShowHorses Horse contains horse details and show contains show details. currently i am having data into the horse table and show table. there is a relationship between showid and horseid maintained into the showhorses table. currently there is no data into the showhorses table. i am trying below query in sql server to get the records using left join. also i have tried the same query using linq but still the same trouble. sho...

  • Issue#601907: filter a table in a query based on a parameter and update remaning tables

    My database has company table containing mutltiple companies. It also has many other tables related to the company table.I want to make reports for a specific company and have created a parameter called company id. I filter out every row in the compnay table that is not equal to that parameter and that works great.My questions is this: Is there a way to remove rows in all other tables where the company does not exist anymore because it has been filtered out using my paramter. Or do I need to man...

  • Issue#655663: Giffgaff - Credit query

    Topped up account Monday with £10, phone used for texts and calls only and credit balance is £0. I've just put another £10 on. Please explain where my credit has gone...

  • Issue#727308: Autodesk - Bifrost playblast query

    Hello, I'm very new to Bifrost, I'm wondering why the collider geo disappears when I playblast my simulation? Is there an option to keep it visible? Best, Tristan...

  • Issue#768552: SQL: Better to connect to raw table and apply steps or filter/join with query?

    We have an on-premise data source (SQL Server 2008 - I know its old...) housing our ERP data (Microsoft Dynamics AX 2009). We are currently using PowerBi to connect to this data using an import connection which is suitable for those current datasets/reports. I am now looking at building out standardised data sets for various finance related functions using Direct Query connections. I am trying to find the best way to set these data sets up. My options so far are: 1. Simply connect to t...