Forum Discussion

venildo's avatar
venildo
Frequent Visitor
4 years ago
Solved

Microsoft.PowerBI.Api - Someone worked with whis library

I need to implement a solution in C# desktop, to access POWER BI, and update the report, that's all. I'm trying with this library but it doesn't work. Could someone give me an example or point out ...
Need Help
Watsky's avatar
Watsky
Solution Sage
4 years ago

Good Morning venildo ,

Can you show me what you're doing and what you're trying to accomplish?

venildo's avatar
venildo
Frequent Visitor
4 years ago

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.

  • Watsky's avatar
    Watsky
    Solution Sage
    4 years ago

    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.

    • venildo's avatar
      venildo
      Frequent Visitor
      4 years ago

      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?

      • Watsky's avatar
        Watsky
        Solution Sage
        4 years ago

        This is found in the Power BI Service Admin Portal. Under Capacity settings. Then you'd click on your capcity.