Forum Discussion

BrandedSaiyan's avatar
BrandedSaiyan
Advocate II
4 years ago
Solved

Possible to Query Keywords in SQL Statement Datasource Using API?

Hello Power BI Community, I recently gained access to the Power BI REST API. I was hoping there would be a way to do a keyword search on the SQL Statement that is part of part of a SQL Server data...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You have to run it against each dataset (that you have access to) separately.  However you can sort of automate that by running the queries from PowerShell.

  • lbendlin's avatar
    lbendlin
    3 years ago
    Invoke-ASCmd -Server "powerbi://api.powerbi.com/v1.0/myorg/<workspace name here>" -Database "<dataset name here>" -Query "select * from `$SYSTEM.TMSCHEMA_PARTITIONS" | Out-File -FilePath c:\users\xxx\Downloads\dmv.xml
BrandedSaiyan's avatar
BrandedSaiyan
Advocate II
3 years ago

Thanks for pointing this out. I'm noticing for a report I'm currently working on I have 3 SQL Server datasources showing under PARTITIONS and 1 SQL Server source showing under EXPRESSIONS. I'm not able to determine the difference or why one shows under expressions. Any further insight is appreciated. 

lbendlin's avatar
lbendlin
Super User
3 years ago

Both are queries.  Partitions are loaded into the Vertipaq engine.  Expressions are not loaded into the engine but may participate in the data pull, especially when other queries depend on them (even when you explicitly state you don't want to refresh them !).

 

You can tell by the italicization of the query name in Power Query.