Forum Discussion
Use Excel to get data from semantic model using parameters
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
Hi jmoedata,
Just following up to check if the solution shared by our Super User helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!
If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.
Best regards,
Prasanna Kumar