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

Errors with tables in workspaces folder #85

Closed Mlzbr1974 closed 3 years ago

Mlzbr1974 commented 3 years ago

Hello,

Thank you for the api its awesome. I have an issue with all tables in workspace groupes (dashboard tiles, dashboards, ..all 14 tables) When i selected it, i have an error : Expression error : Sorry we can't find column 1 from table;. Details : column 1 ****

Same issue with Gateway section : Can't find id colum from table GetData & GetRawData : DataSource.Error : Web.contents can't get the content of "https//api.powerbi.com/v1.0/myorg 404 not found. DataSourceKind=PowerBIRESTAPI DataSourcePath=PowerBIRESTAPI Url=https://api.powerbi.com/v1.0/myorg

I have the rights of PowerBI admin

Could you help me? Thank you

migueesc123 commented 3 years ago

Hey,

I can't repro. Are you able to repro that scenario in a different tenant? (if you have any)

I'd recommend using something like Fiddler to trace the calls that you're making against the REST API and see the exact response that you're getting from the API to check if you're getting the result that you're expecting.

@ImkeF @klinejordan Are you guys able to repro? Not sure what could be causing those sort of issues.

Mlzbr1974 commented 3 years ago

I try directly on my company network and same issue. I resolve the problem for the gateway (add user to gateway administrator) Same issue for the rest

klinejordan commented 3 years ago

Just being a Power BI admin doesn't mean you'll be able to use the APIs in the Workspace group or the Gateway group. You'll be able to use the Power BI Administrator APIs, but not necessarily the other ones.

For gateways, you need to be an admin on at least one gateway cluster for those APIs to return any information.

For the Workspace group, you need to be a member of at least one workspace that's not your personal workspace.

Have you met those prerequisites?

Mlzbr1974 commented 3 years ago

hello @klinejordan, Thank you for your message. I try the Power BI API with Admin Global and same issue. For the gateway, I wasnt registered, now its working fine. For the Workspace group, I dont now I will try sir. I let you know the issue.

migueesc123 commented 3 years ago

Thanks for the hindsight @klinejordan !

I was able to repro that situation on a different tenant and its by-design how the API works. I'm closing this one as it appears to be working as intended.