Forum Discussion
Helper IUnwanted dataset created on thin reports
As noted in this documentation...
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
The highlighted section (below) indicates that when field parameters are used, they are stored in local model/dataset.
Helper Ihnguy71 Further finding...
I found, what I believe is the reason for the mixed storage. In the report files, I am using a slicer control to dynamically set the Y-Axis of a chart as outlined in the following Guy In A Cube GuyInACube video
https://youtu.be/1eurc0EY2Xg?si=w4SZRfLINvu43iiZ
As noted in the video, to achieve this functionality, you must set a field parameter for the dynamic Axis.
When the data layer is separated from the report file, the field parameter is being set to "IMPORT" instead of Direct Query mode. So... progressing this troubleshooting, I'm now trying to change this to a direct query, but the Storage Mode property is grayed out.
Helper IAs noted in this documentation...
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
The highlighted section (below) indicates that when field parameters are used, they are stored in local model/dataset.