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.
Hi Team -We would like to query power bi dataset programmatically using DAX . We have set up linked server in SQL Server (( installed sql server on Azure VM) . However , When I click on test connection the connection fails with access error . Can some one please suggest how to fix it or alternative options (( Note / I have looked into executeQueries Api but it doesn't Suppport PBI dataset with RLS. We have RLS in our dataset
Thanks,
Abhiram
@abhiram342 , Are you able to acess the sql server using sql server management studio on the machine you have power bi. Have you opened the port and done ip whitelisting?
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |