search

migueesc123 / PowerBIRESTAPI

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

Issue with DataSet Datasources table #84

Open Karthik7373 opened 3 years ago

Karthik7373 commented 3 years ago

Thanks for providing the custom connector…this is really helpful. Am powerBI admin in our organization and i have one issue regarding this connector..when i select dataset datasources from PowerBI Service Admin tab i get below error

Failed to save modifications to the server. Error returned: ‘OLE DB or ODBC error: [Expression.Error] The field ‘datasourceId’ of the record wasn’t found..

I have everything i need but this data from dateset datasources would give me datasource ID which i want to join with datasource id from gateway tables to get the list of datasets connecting to oracle.

Please help as we are in middle of migrating oracle to Postgres and this information is very critical.

Karthik7373 commented 3 years ago

Thanks for providing the custom connector…this is really helpful. Am powerBI admin in our organization and i have one issue regarding this connector..when i select dataset datasources from PowerBI Service Admin tab i get below error

Failed to save modifications to the server. Error returned: ‘OLE DB or ODBC error: [Expression.Error] The field ‘datasourceId’ of the record wasn’t found..

I have everything i need but this data from dateset datasources would give me datasource ID which i want to join with datasource id from gateway tables to get the list of datasets connecting to oracle.

Please help as we are in middle of migrating oracle to Postgres and this information is very critical. @migueesc123 Please help

migueesc123 commented 3 years ago

Hey! Due to some unforeseen situations that I’m going through, I’m focusing 100% of my available time for remote consultancy work.

I’ll let @klinejordan and @ImkeF chime in and provide their suggestions for your scenario.

Please note that the code for the connector is under the MIT license, so you’re able to fork the repo and modify the code of the connector to fit your requirements as long as you provide attribution.

I noticed that you tagged me in this issue, so I wanted to reply as soon as I could so you’re aware of my current situation and hopefully get some feedback from the other contributors of this repo.

if you still require professional help personally from me, you can reach me at info@poweredsolutions.co where we can discuss further what changes you might need for the connector, deliverables and rates.

Best!

ImkeF commented 3 years ago

Hi @Karthik7373 , also don't have time atm to dig deeper into this. But if you need data just for an ad-hoc analysis, you can always use the manual retrieval from the API page itself: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasources-as-admin This would at least give you a hint if there is any issue with the scopes of your app itself.

klinejordan commented 3 years ago

You'll see this if there's a "corrupted" dataset in your tenant where Power BI can't find the data sources for some reason. Unfortunately fixing this would be a big project as it involves implement try behavior in PQ, which also makes debugging more difficult so its a double edged sword. And there's also a reason this API is in our experimental folder - because the people who contribute to this connector can't necessarily guarantee performance. This isn't something I can tackle in the near term unfortunately but we can leave it open as a known issue in case other contributors want to take a stab at it.