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

Get Table and Measures #91

Closed theapemother closed 3 years ago

theapemother commented 3 years ago

Hello,

I am wondering how to use this API connector to get the table information of a dataset. I see in the documentation this is possible and im wondering if I need a new connector to do this or have to edit my PowerQuery script, or something else?

let Source = PowerBIRESTAPI.Navigation(), AppWorkspace = Source{[Key="AppWorkspace"]}[Data], Datasets = AppWorkspace{[Key="Datasets"]}[Data] in Datasets

migueesc123 commented 3 years ago

Hey! Could you please share the link to the reference of the documentation ? If it's supported by the REST API, then there's probably a way to make it happen with this connector

klinejordan commented 3 years ago

If you are looking for a list of tables/measures/columns in a dataset, that is only available using the Scanner API, which this custom connector does not currently support: https://powerbi.microsoft.com/en-us/blog/scanner-api-is-now-in-ga/

M is unfortunately not a great language to handle the polling required to use the scanner API

theapemother commented 3 years ago

Thank you all! Very much appreciated.