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.
I followed the tutorial here to add a Developer Visual to my Power BI report: https://github.com/xiaodongliang/forgeviewer_embed_in_powerbi_report
Now I want to populate the table in the report with data from a local SQL Server DB.
But the only way to add a connection to SQL Server is using Power BI Desktop and there is no Developer Visual in Power BI Desktop.
I tried creating the dataset on Power BI Desktop, publish it and then add the Developer Visual instance on the web, but the connection between visual and table was not made.
My question is how can I add data from a SQL database to the table connected to the Developer Visual?
Hi @Anonymous ,
It seems that this project can only use .xlsx files as data source files. If you want to use SQL Server DB as a data source, you need to modify his project code or customize developer visual.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, thank you for your answer. How can the developer visual be customized in this case?
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |