Making queries dynamic in Power Query
Join us for an insightful session with Rick de Groot , where he'll demonstrate how to avoid common errors caused by hardcoding values in your queries. Instead, learn how to dynamically apply logic to your queries, ensuring they adapt seamlessly to changes in your underlying data. Don't miss this opportunity to enhance your Power Query skills and make your data processes more robust and efficient. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: WWW.YOUTUBE.COM/@DATABIS Language: English
Dataset in report has null in colunm, but data exists when executing query in SSMS or DaxStudio
Hi all, Strange thing here. I have a dax query which works fine in SSMS and in Dax Studio when I connect to SSRS-Server instance. But the same query shows for one column all null values in Report Builder when testing my report. What can it be ? Here is the query : EVALUATE SUMMARIZECOLUMNS ( 'Datum'[Maand], 'StockTerminal'[LocationName], 'YearChart'[GroupedCommodity], 'Datum'[Datum], 'Datum'[JaarMaand], 'Datum'[Jaar], FILTER ( VALUES ( 'YearChart'[GroupedCommodity] ), ( 'YearChart'[GroupedCommodity] <> BLANK () ) ), KEEPFILTERS ( TREATAS ( { "ARRIVED" }, YearChart[InboundStatus] ) ), FILTER ( VALUES ( 'Datum'[Jaar] ), ( 'Datum'[Jaar] = YEAR ( TODAY () ) ) ), "Qty", [Qty], "QtyPreviousMonth", [QtyPreviousMonth], "QtySamePeriodeLY", [QtySamePeriodeLY], "QtySamePeriode2YAGo", [QtySamePeriode2YAgo], "Difference", ( [Qty] - [QtySamePeriodeLY] ), "Difference2423", ( [QtySamePeriodeLY] - [QtySamePeriode2YAgo] ) )
Break a Line Graph when no data
Hi, Is there anyway to break a line graph when no data is present on a combo bar/line graph? No data was collected from 2019-2022 and the bars reflect this, however the lines look like there is data: I have tried to change to type to 'Categorical' however this then doesn't show it in date order, which it needs to be as it needs to show yearly changes in numbers. I could set to 0 but that would then look like there was sharp increase from 2022 to 2023 so ideally looking for a full break if possible. Is there a solution to this? Thank you
Query Regarding Report Display
Hi Community Members, Hope you are doing well, I had a small query regarding display options of a report in Power Bi Service, when I publish the report from my desktop app to service I want only the report to display and hide all the options above it and the navogation panel in side, (attaching screenshots of what I want to hide for your reference) Is there a way I can do this? Thanks a lotPower BI Url query paramters not working
Hi All Need some help about this queries in power bi. I have a report (I only have read/view) rights on it and I want to query it via url. I have create my URL, the report loads but nothing is filtered. I saw that you need to be careful of spaces in the query and all thoose limitation and as far I can see I got that right. Out of option so looking is there any additional tip I should try. Here is my table name with its column name and the filter I am trying. I just dont get it why its not filtering. https://app.powerbi.com/groups/<someprivateurl>?filter=MIM_MART_FACT_DFO.DM_F_DIP_TRANS_POSITION_LOSS_PREVENTION/Locations eq 'GENN'
Add parameter in query designer (query from Power BI Performance analyser)
Hi guys, I am trying to add a parameter in my report and add the parameter in the query designer module. The query was generated within Power BI via Performance analyser. I saw different posts on this issue but no clear solution. First I have tried to create a parameter in the report (in my dataset properties) and add it with @ in my query such as // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({@Test}, 'FACT - Conflicts'[Conflict category]) However, I have an error message that the parameter test was not declared. So I declared it again through "Query Parameters" module within the query designer (same name and another name). This time I can execute the query but it returns no row with a default value "Group" (which should not be the case - if I had put TREAT({"Group"}, it returns some rows). I tried to see what were the values in the Parameters properties window and I can see this. Which I don't understand because "Test" is not the name of my dataset.. Any idea to resolve this? Thanks a lot in advance!
Server refresh gives Table not found error but fine in desktop
I'm trying to set up my scheduled refresh for my PowerBI report - the connection is an ODBC on import, I have the required drivers and get a green check when I test the connection, however when I refresh I get the following error: SessionID: b5ba2f83-45cb-4fab-8a0e-8a79b6cdbf0c [0] -1055784932: DataSource.Error: ODBC: ERROR [42S02] [Cache ODBC][State : S0002][Native Code 30] [D:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\MDataEngine\Mi] [SQLCODE: <-30>:<Table or view not found>] [Location: <Prepare>] [%msg: < Table 'DBO.DSKILLSETSTAT' not found>]. DataSourceKind = Odbc. DataSourcePath = dsn=MYDSNLOCATION. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055129594: The current operation was cancelled because another operation in the transaction failed. [3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. My refresh works just fine in PowerBI desktop, no issues with queries on any tables, it's clearly connecting to the source ok, I'm not sure what I'm missing. I can refresh and save the updated file in desktop and the report data refreshes on server. I'm not sure how or why it can't find the table any more. Here's a snip of the connection structure if I'm creating a new source - the table being queried is called dSkillsetStat in the dbo folder
