Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
As far as I know, Javascript is a client side pl so we cannot perform sql requests. But for Typescript we can as long as we install the needed package and dependacies.
So, can we perform some sql requests like fetch data from an external database using typescript ?
Hello @Anonymous,
Please pay attention to the fact that Power BI Visuals Tools compile TypeScript code into JavaScript. However, I suppose that it's possbile to perform SQL queries from the client side. You just need to find a proper library (I don't happen to know about such libraries).
However, it isn't a good to perform SQL queries from client side because of an ability to inject own third party code that might destroy the database or get some secure data.
I recommend that you shouldn't execute any kind of SQL quesries form the client side in order to keep secutiry and protect database from XSS.
I'd would recommend to use some kind of REST API.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |