Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.