search

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
237 stars 74 forks source link

Dataset Datasources refresh not working #182

Closed mayurvgajera2023 closed 10 months ago

mayurvgajera2023 commented 1 year ago

It loads preview data but when refreshing the data, all the other tables refresh ok but dataset datasources is not refreshing. It keeps waiting for PowerBIRestAPI

mayurvgajera2023 commented 1 year ago

I think Microsoft has updated the mechanism to pull this data and someone needs to update the code.

migueesc123 commented 1 year ago

I think Microsoft has updated the mechanism to pull this data and someone needs to update the code.

This doesn't appear to be the case. You can check their documentation: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasources

and then the lines of code at the connector level that do the calls: https://github.com/migueesc123/PowerBIRESTAPI/blob/9d6ca60efa296e1efbdb861b7585c0fb169a4cb3/Power%20BI%20API/PowerBIRESTAPI/PBIAPI.pq#L1048-L1080

I'd recommend checking what response you're getting from the REST API by using something like Fiddler to see the calls and responses at your network level, then seeing if perhaps there's an issue in terms of permissions to that endpoint.

If there isn't, and you're still seeing issues with that particular node - object, then please share the error message that you're getting when you try to run this table in Power BI Desktop and what query you're trying to evaluate.