Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
does the new august update what if parameter not work on direct query?
please advise
Nikki
Solved! Go to Solution.
Hi Nikki,
According to my test (Sql Server DB), the What If parameter isn't available in Direct Query mode. What if parameter creates a new table actually, while no new table can be created in Direct Query mode. Maybe this is one part of the reason.
Best Regards!
Dale
Does it still not working on direct query ?
Hi Nikki,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi Nikki,
According to my test (Sql Server DB), the What If parameter isn't available in Direct Query mode. What if parameter creates a new table actually, while no new table can be created in Direct Query mode. Maybe this is one part of the reason.
Best Regards!
Dale
thanks Dale - not ideal but at least we know now. thank-you for your help.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |