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.
Is anyone able to explain how Power BI reads stored procedures from Sql Server? For instances it seems that if I connect to a table from Sql Server, Power BI is able to see that this is already a table and can easily connect to the data. On the other hand, when I try connecting to stored procedures, Power BI seems to struggle mapping it out. Are there different ways to write the code when you are trying to Import stored procedures? I'm currently using Microsoft Sql Server 2012, and I'm not sure if that is an issue until we update to Microsoft Sql Server 2016. Any help would be greatly appreciated.
Thanks
Hi @nleuck,
About use sp in power bi, you can refer to below thread:
Regards,
Xiaoxin Sheng
Hi @nleuck,
Power BI Desktop works ok with Stored Procs, You'll just need to take care you always return 1 dataset and never more than 1 dataset..
I think if your SP returns more than 1 result it ignores the additional procs.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |