Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've a report which connects to a snowflake database and shows needed visualizations for a big list (250000 candidates) and I've a request from the user community to be able to filter the visualizations based on their list of candidates (10 to 15k) at a time which they have in local Excel files.
I've seen vidoes where excel and parameters are being used to filter reports, but when using Direct Query I am unable to do so.
Any information or insight is highly appreciated!
Fyi- I am a beginner/amatuer with PowerBi !
Thanks for your help!
Solved! Go to Solution.
HI @ssoman,
It is impossible to add local file to power bi when you used directquery mode.
Use DirectQuery in Power BI Desktop
Please switch to import mode to get data from two datasources to achieve your requirement.
Regards,
Xiaoxin Sheng
HI @ssoman,
It is impossible to add local file to power bi when you used directquery mode.
Use DirectQuery in Power BI Desktop
Please switch to import mode to get data from two datasources to achieve your requirement.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |