Forum Discussion
Writing back to sql server from PowerBI
Hi ,
Is there a way to read the KPI created in power bi using Sql server using pro licence?
for ex : here the price is calculated using value/volume and the requirement is that we need to read this price created in power bi in sql server for every id.
| ID | Price |
| 1 | 123 |
| 2 | 100 |
| 3 | 150 |
Hi, as1195
Yes, it is possible to read KPIs created in Power BI using SQL Server. However, it depends on how the KPI is created and stored in Power BI.
If the KPI is created using a measure in Power BI, you can write a DAX query to retrieve the measure value from Power BI and store it in SQL Server. You can use the Power BI API to retrieve the measure value.
If the KPI is created using a visual in Power BI, you may need to extract the data from the visual and store it in SQL Server. You can use the Power BI REST API to extract the data from the visual.
Please note that to use the Power BI API, you need to have a Power BI Pro license.
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, as1195
Yes, it is possible to read KPIs created in Power BI using SQL Server. However, it depends on how the KPI is created and stored in Power BI.
If the KPI is created using a measure in Power BI, you can write a DAX query to retrieve the measure value from Power BI and store it in SQL Server. You can use the Power BI API to retrieve the measure value.
If the KPI is created using a visual in Power BI, you may need to extract the data from the visual and store it in SQL Server. You can use the Power BI REST API to extract the data from the visual.
Please note that to use the Power BI API, you need to have a Power BI Pro license.
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Would this work on when using powerBi as a data entry tool?I have a dashboard for my clients and they will enter the details in the dashboard , i want that to be written back or updated on the sql server , is that possible ?
