Forum Discussion

whu's avatar
whu
New Member
4 years ago
Solved

How to get a parameter in a slicer?

Hi, I've created a parameter in my Direct Query Dashboard, which can be used as input in "Data source settings" for the server name (see picture below). This works fine; within the Power Query Edi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI whu,

    For the parameterized report, you need to enter to data source setting to change the parameters then it can affect the data connections:

    Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

    For your scenario, I'd like to suggest you take a look at the following link about preview feature dynamic M query parameters. 

    Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

    Notice: current this feature does not work for direct query mode data source, please use the import mode table instead.

    Spoiler

    The feature is only supported for M based data sources. The following DirectQuery sources are not supported:

    T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (such as Azure Synapse Analytics (formerly SQL Data Warehouse)), and Synapse SQL OnDemand pools
    Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
    Other unsupported data sources: Oracle, Teradata, and Relational SAP Hana, PostgreSQL
    Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI whu,

For the parameterized report, you need to enter to data source setting to change the parameters then it can affect the data connections:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

For your scenario, I'd like to suggest you take a look at the following link about preview feature dynamic M query parameters. 

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

Notice: current this feature does not work for direct query mode data source, please use the import mode table instead.

Spoiler

The feature is only supported for M based data sources. The following DirectQuery sources are not supported:

T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (such as Azure Synapse Analytics (formerly SQL Data Warehouse)), and Synapse SQL OnDemand pools
Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
Other unsupported data sources: Oracle, Teradata, and Relational SAP Hana, PostgreSQL
Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

Regards,

Xiaoxin Sheng