Forum Discussion

jmoedata's avatar
jmoedata
Frequent Visitor
1 year ago
Solved

Use Excel to get data from semantic model using parameters

I have a use case where we need to bring data from a PowerBI semantic model into Excel, but would like to only return a subset of data to Excel based on input parameters in Excel that are selected by...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jmoedata,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    And also, Thanks to lbendlin  for prompt and helpful solution

    Excel’s live connection to a Power BI semantic model (via PivotTable > From Power BI) creates a thin client connection that allows slicing and filtering after the data is loaded, but it doesn’t support parameter-driven filtering before retrieval. Power BI Service parameters are only used during dataset refresh and have no effect on what Excel pulls in. To limit data at query time, the best workaround is using DAX Studio or Power Query with the XMLA endpoint, where you can write custom DAX queries and even pass Excel cell values as parameters to filter data before it loads into Excel.

    If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.


    Thank you & Regards,
    Prasanna Kumar

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jmoedata,

 

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

 

Best,

Prasanna Kumar