search

migueesc123 / PowerBIRESTAPI

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

https://api.powerbi.com/v1.0/myorg 404 Not Found #142

Closed JackCoxer closed 1 year ago

JackCoxer commented 1 year ago

I have added the connector in to Power BI Desktop, and i'm able to add tables and view the data in them within Power Query, however when I try and add the tables I get an error message:-

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown.. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. '.

I tried adding in the GETData function, as I thought that may be the issue, however the error message i'm getting is:-

DataSource.Error: Web.Contents failed to get contents from 'https://api.powerbi.com/v1.0/myorg' (404): Not Found Details: DataSourceKind=PowerBIRESTAPI DataSourcePath=PowerBIRESTAPI Url=https://api.powerbi.com/v1.0/myorg

Can anyone shed any light? I'm new to APIs etc so any help would be greatly appreciated.

migueesc123 commented 1 year ago

hey! can you share any repro steps?