March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I'm connecting SQL Server with PowerBI via Direct Query.
I have a Table in a report which gets data from a dimension and fact table with a one-to-many bidrectional relationship.
The issue is, in the 'Visual Level Filters' section, I'm not able to filter values for some of the fields from the dimension table.
Any help would be appreciated.
Thanks.
Hi hvan-user2,
I just tested at my side, and didn't encounter the issue you mentioned. Connecting to SQL server Analysis Service with Direct Query.
I suspect this should be mostly related with the data type in your data model. Please take a try to enable Tracing in Power BI desktop, see if we could get any further helpful information from the trace log.
File -> Options & Settings -> Options->Global->Diagnostics, check the tracing
And upload the trace log into OneDrive, then post the shared link here.
Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |