August 1, 2022 at 12:00 am
Comments posted to this topic are about the item How to Get Data Using Python in Power BI
August 1, 2022 at 4:55 am
With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like Python?
If you CAN get the data directly, is there any advantage to using Python to get the data you want instead of, say, calling a stored procedure? I can see that it might be a little easier to get CSV data from a file but what about getting data from SQL Server?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2022 at 7:16 am
This was removed by the editor as SPAM
August 2, 2022 at 1:30 pm
This was removed by the editor as SPAM
August 3, 2022 at 3:02 pm
With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like Python?
If you CAN get the data directly, is there any advantage to using Python to get the data you want instead of, say, calling a stored procedure? I can see that it might be a little easier to get CSV data from a file but what about getting data from SQL Server?
@ Daniel Calbimonte,
Any chance that you could provide an answer to the question I asked, repeated as a quote above for your convenience?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2022 at 3:08 pm
In my opinion, to get data, I would prefer to transform and convert it using a stored procedure or DAX. To extract data, I would use Python, if there are some formulas only included in Python and not available in T-SQL or DAX to convert or transform the data.
August 3, 2022 at 4:13 pm
Thank you for the feedback, Daniel. I appreciate it.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply