The Query contains the "XXXX" parameter, which is not declared.
Hello, I am trying to use "Paginated Report" on top of Power BI dataset. My dataset is a "Direct Query" connection on Azure datalake. In order to create Paginated report with parameters, while creating dataset, I am using the query obtained through "Performance Analyzer" as shown below: // Direct Query Define MEASURE 'FactVolume'[ASDQ_GRs] = [Gross Receipts] MEASURE 'FactVolume'[ASDQ_CCAs] = [CCA] var ASDQ___DS0FilterTable3 = TREATAS({@KPI}, 'DimMeasures'[Measure Name]) var ASDQ___DS0FilterTable4 = TREATAS({"Treatment"}, 'Product'[Level 4 A]) var ASDQ___DS0Core = SUMMARIZECOLUMNS( 'DimDate'[Date], ASDQ___DS0FilterTable3, ASDQ___DS0FilterTable4, "GRs", [ASDQ_GRs] ) EVALUATE ASDQ___DS0Core ORDER BY 'DimDate'[Date] DESC I have created the parameter in "Query Parameters". In spite of declaring the parameter, I am constantly receiving below error: "OLEDB or ODBC error: The Query contains the 'KPI' parameter, which is not declared. What am I doing wrong? Do "Parameters" work with Power BI dataset connection which are of type "Direct Query"? Can you please help me to resolve this issue? Thank you so much. pabeader
Cannot reference a non numeric measure in DAX from another Power BI dataset
Hi team, I connected with company sever via getting data from "PBI datasets". But when I create new measures, I find that I can only reference numeric fileds from that dataset. Non-numeric fileds cannot be found when I try to reference them (but they are indeed in the fileds of that dataset). May you please help? Thank you. Best Regards, MiaDAX Measures for Date while using Power BI Dataset
Hi, I am fairly new to Power BI. I am using a dataset (Power BI dataset) as the source for my new report. I am trying to create a new measure using data calculations. Essentially, I have a column [Partner Deal Created Date] with date values: yyyy-mm-dd I would like to add a measure column next to it with the previous month value (integer). Example ideal output: Partner Deal Created Date previousMonth 2021-07-30 6 2021-06-30 5 2021-05-30 4 However whenever I try to perform a PREVIOUSMONTH (or just about any Date calculation for a measure), I get the following error when I add the measure to a table. Formula: previousMonth = PREVIOUSMONTH('xxxxxxxxx xxxxxxxxxx'[Partner Deal Created Date]) Is this a limitation of using a Power BI dataset as the source or can this be achieved using a different formula? My end goal is the be able to have a Measure as part of a slicer (which does not seem possible - I cannot add measures to slicers). Thanks in advance!
Use Power BI Pro Dataset as Data source in SSRS Reports
We have a client using SSRS reports and Power BI reports using SSAS As source. Now we are going to remove the dependencies of SSAS. So we are going to migrate the SSAS models as Power BI datasets and trying to use the Power BI (Pro) datasets as source in SSRS reports. Will it possible? If yes, please provide the steps.File based on the Power BI dataset shows wrong data.
Good day, I have the following issue: I have created a page using the Power BI desktop. Then, I published my dataset. I used this dataset to be a data source for another Power BI desktop file. However, the results I am getting are different (I apply the same filters, tried removing them, but it did not help): Dataset screenshot (desktop file that was published to be a data source) https://snag.gy/TKu05b.jpg Second report (data source - published file) Why do I get different results? I use the same data, same filters, etc. (tried resetting them - did not help me as well)
