Forum Discussion

hhus4242's avatar
hhus4242
Regular Visitor
5 years ago
Solved

Display folder for report measures on live data connections

I have a report with a live connection to a power bi data set - Is there a way to move locally defined measures to display folders? The field to type in display folder names is greyed out and drag and drop is not working.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi hhus4242 

    When the mode is Live connection , you cannot move locally defined measures to display folders unless convert the mode to Direct Query .

    If the data source is Power BI dataset or Azure Analysis Service , you can change the model to Direct Query . If the data source is not the two I mentioned, you have no way to switch the mode in the Desktop .

    The link below is to introduce how to change the model from Live connection to Direct Query when the data source is Power BI dataset or Azure Analysis Service .You can refer to it .

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi hhus4242 

    When the mode is Live connection , you cannot move locally defined measures to display folders unless convert the mode to Direct Query .

    If the data source is Power BI dataset or Azure Analysis Service , you can change the model to Direct Query . If the data source is not the two I mentioned, you have no way to switch the mode in the Desktop .

    The link below is to introduce how to change the model from Live connection to Direct Query when the data source is Power BI dataset or Azure Analysis Service .You can refer to it .

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • hhus4242 , Not when this is live connection. If you try to add new table using enter data, it can move this model to direct query, then you can it there