Data Source Can't Use Design Query
Hello, I am trying to create a parameter so that once the user select a category, the report will be filtered and generated based on that. A video I found instructed that I create the parameter in "Query Designer" which mine is grayed out. In addition, I noticed that every time I try to access the Datasets, it says that I have to configure connection (FYI my data is pulling from an excel file on my personal OneDrive). Am I having issues because my data is saved on OneDrive instead of Azure? How do I go about to fix this? TYSM!
WHERE Syntax Error - Query preparation failed. (Power BI Report Builder)
Hi, In Report Builder this statement works fine using ORDER BY : EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) ORDER BY 'ReferenceList'[Location] ASC BUT when i try to filter on Location = 'Europe ' using the WHERE statement it produces an syntax error EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) WHERE 'ReferenceList'[Location] = 'Europe' TITLE: Power BI Report Builder ------------------------------ Query preparation failed. ------------------------------ ADDITIONAL INFORMATION: Query (1, 180) The syntax for '<ccon>WHERE</ccon>' is incorrect. (<ccon>EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) WHERE 'ReferenceList'[Location] = 'Europe'</ccon>). (Microsoft Analysis Services) ------------------------------ BUTTONS: OK ------------------------------ Help is appreciated Thanks
