Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two identical SQL Server DBs hosted in two different servers. I want to create a report so that I can switch between both the servers and see data accordingly. I have followed this video and managed to do it upto some extent but it is not getting successful result. Below are the steps I followed, can you point if I'm doing anything wrong?
1. Created a DirectQuery data source
2. Created a parameter - Company (string)
3. Created a table using 'Enter Data' to house two Company names - tblCompany (ComName string)
4. Bind the parameter 'Company' to ComName in above created table
5. A slicer added in the report to select between companies in tblCompany
Worked fine upto this point..
6. Changed in M query of 1st direct query dataset to change data source according to the parameter:
Now the report is giving error on visuals from DirectQuery table:
What is this error? Is there any other way to get this done?
TIA
Hi @itsMeKapz ,
Based on the current capabilities of Power BI and as of my latest knowledge, slicers and query parameters work on different levels, you can't use a front-end slicer to influence back-end query parameters.
Reference: Dynamically Change Data Source Using Parameter and... - Microsoft Fabric Community
However, you can refer to the method in the following link as a workaround.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |