Forum Discussion
How to change Parameter setting using Selected Value from a Slicer Visual
Hello raymondwkmok - thanks for posting to the community. In order for 'bind to parameter' to be visible and work, the tables being filtered by the parameters must be direct query as opposed to import mode. At this time SharePoint is not supported as a direct query source without first syncing it with some other location such as Azure SQL then using that as the source. However, it is still possible for you to utilize parameters to limit the volume of data. Instead of using report slicers to select the values of the parameters, you can use on of these methods below. Please let me know if there is anything else I can help with for this.
From PowerBI Desktop: Home > Transform Data > Edit Parameters
From the PowerBI service: Dataset Settings > Parameters
From Deployment Pipelines: Dataset > Deployment Rules > Parameter Rules
Hello raymondwkmok - thanks for posting to the community. In order for 'bind to parameter' to be visible and work, the tables being filtered by the parameters must be direct query as opposed to import mode. At this time SharePoint is not supported as a direct query source without first syncing it with some other location such as Azure SQL then using that as the source. However, it is still possible for you to utilize parameters to limit the volume of data. Instead of using report slicers to select the values of the parameters, you can use on of these methods below. Please let me know if there is anything else I can help with for this.
From PowerBI Desktop: Home > Transform Data > Edit Parameters
From the PowerBI service: Dataset Settings > Parameters
From Deployment Pipelines: Dataset > Deployment Rules > Parameter Rules
Hi Jennratten, thanks for the advice and much appreciate the great suggestions.
Based on your advice, I've created a list of "Store Names" at Power Query then use it at the PQ Parameter; Now I can select store name from a dropdown menu while I'm changing the store name at Parameter Edit of Power BI Desktop.
Unfortunately, the users of my BI Report will not be able to change the parameter at Power BI Service after I published the report.
If I have no permission to use SQL Server, I'll have to wait for Microsoft extending the use of Dynamic M Query Parameter to other data source like SharePoint.
Thanks
Raymond