Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello all:
I usually query SQL databases from our SQL server by typing in the SQL code right in the advanced options instead of importing the entire table into Power BI Desktop. This results in huge improvements in performance (Merges that were taking 40 minutes to run on my laptop now run in seconds on the SQL Server).
I was wondering, since Python and R are part of the "Machine Learning Services" in SQL Server Management Studio, does Power BI feed any typed Python/R code back to the server for processing, or will it result in an error?
Thanks a lot!
Solved! Go to Solution.
Hi @Anonymous ,
After my tests, you could only input SQL statement. Python/R code will return errors.
Hi @Anonymous ,
After my tests, you could only input SQL statement. Python/R code will return errors.
Ok, thanks a lot!
Looks like we'll have to create views in SSMS.
Thanks again.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |