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
Chart with last 4 weeks' data and secondary chart with just last week's data
Hello! This is my first forum post so please be understanding if I post too much info, I want to be 'easy' to help 🙂 I am trying to show 4 weeks of data in a chart, which is easy, but on the same power bi page in a different chart, show the most recent week worth of data too. I have the data automatically uploading from a database source. The data I have currently looks like this in my query, with the current chart showing the equipment name on x axis, and the OEE percentages on Y. There is a slider that is linked to Shift ISO column so that the last 4 weeks of data can be displayed. Is there any way to make a chart that only shows the last week's worth of data based on the time of accessing the power bi? thank you!
