Forum Discussion
Microsoft.PowerBI.Api - Someone worked with whis library
- 4 years ago
Hey venildo,
Take a look at some of these links:
Refresh PowerBI reports using C# and web API – Dynamics CRM Tech Blogs (wordpress.com)
Good Morning
First of all thank you very much for the answer I saved my life, hahah
Can I ask for one more thing?
You would have a link demonstrating how to use the update-datasources API, as I'm having difficulty in parameterizing it to configure the database paths to update the BI.
I'm using 3 different data sources, SQL Server, MySql and Access.
Thank you very much
Good Morning venildo ,
Can you show me what you're doing and what you're trying to accomplish?
- venildo4 years agoFrequent Visitor
Good afternoon!!!
My goal is very simple, I have an application that updates several databases (Access, MySql Server and SQL Server) and after updating these databases I need the PBIX to be automatically updated through the application.
I've been testing the online power bi refresh button and it doesn't seem to work, as the report is not refreshed, it's only refreshed when I refresh from the desktop, so I was in doubt if I would use the refreshest API (https://api. powerbi.com/v1.0/myorg/datasets/{0}/refreshes) will work or do I need to update the databases path through the api https://api.powerbi.com/v1.0/myorg/datasets /{datasetId}/Default.UpdateDatasources.
My project is being developed in .Net (VB.Net, but if the examples are in C# I know no problem.)
Thank you so much for your help as always.- Watsky4 years ago
Solution Sage
One of the things you'll want to check is if you have XMLA Read/Write enabled. You will need that to refresh outside of Power BI.
- venildo4 years agoFrequent Visitor
Thanks again for your attention.
Where do I see it?
If it's on the Azure Portal, I've already put in all possible permissions.
Do I need to do some configuration inside Power Bi?