Forum Discussion

rjhale's avatar
rjhale
Helper V
1 year ago
Solved

DAX Info Functions Against Published Datasets

Hello,   As part of a Power Automate Flow that we setup months ago, we were using the new DAX Info functions to pull metadata regarding partitions and expressions.  These queries have been working ...
Need Help
  • rjhale's avatar
    rjhale
    1 year ago

    I've had an open support request with MS since this started happening back in January.  I recently started up the conversation again, and I just heard from their engineers this morning that they fixed the issue.  I checked our Power Automate Flow has been failing on that step since January, and it did successfully run this morning.  It seems that the issue should be resolved now.  

     

rjhale's avatar
rjhale
Helper V
1 year ago

It seems that they're pushing us to XMLA endpoint queries for the time being.  I'm exploring this option now, but I'm running into another issue related to pulling that content. 

 

I have a table with a field for Workspace and field for Dataset name.  I'm trying to create a function that I can pass those in as parameters and then return the partitions for each dataset like so:

(Workspace as text, Dataset as text) as table =>
    let
        Query = "EVALUATE SELECTCOLUMNS(INFO.PARTITIONS(), [QueryDefinition])",
        Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/" & Workspace, Dataset, [Query=Query, Implementation="2.0"])
    in
        Source

 This works fine locally, but cannot be refreshed because of the dynamic content.  The error we get in the service is "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed."

 

Any thoughts on how I can work around this problem?