Data Source Can't Use Design Query

[AliceTran1643]

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!

[v-sgandrathi · Accepted solution]

Hi @AliceTran1643,

The behavior you're seeing is likely because your data source is stored in your personal OneDrive. When an Excel file is saved there, Power BI Report Builder treats it as a local file, which limits features like Query Designer, query parameters, and dataset credential settings. This is why Query Designer stays disabled and you're repeatedly prompted to reconfigure the connection.

To resolve this, move the Excel file to a supported location such as SharePoint Online or OneDrive for Business. These options allow for proper authentication, so after reconnecting the file in Report Builder, the dataset should authenticate and the disabled options should become available. Alternatively, you can use an On-premises Data Gateway if you prefer to keep the file local.

Thankyou.

[AliceTran1643]

thank you so much! 

[123abc]

Community Solved solution:

Solved: Power BI Report Builder- Query Designer not showin... - Microsoft Fabric Community

Solved: Query parameters greyed out in Power BI Service - Microsoft Fabric Community

Solved: Re: Parameter greyed out/disabled in the Power BI ... - Microsoft Fabric Community