Forum Discussion

Christian_Heinz's avatar
Christian_Heinz
Icon for Helper I rankHelper I
5 years ago
Solved

ADX DataSource with DirectQuery and M-Parameter not working

Hi everyone, we have found an issue with Power-BI Service and ADX Data source. We want to configure our BI Reports against different deployment stages and are using parameters to switch the data so...
Need Help
  • Christian_Heinz's avatar
    Christian_Heinz
    5 years ago

    Hi,

    here a short update: After I posted that issue to the ideas forum, i got a suggestion to change "AzureDataExplorer.Contents" to the legacy mode "Kusto.Contents" which solved that problem.

    Here my complete (fixed) query script:

    let
    Quelle = Kusto.Contents(EnvironementSwitchADX, null, null, null),
    public = Quelle{[Name="public"]}[Data],
    PUB_TSM_FN_Issues1 = public{[Name="PUB_TSM_FN_Issues"]}[Data]
    in
    PUB_TSM_FN_Issues1

    Unfortunately, my idea request was removed. So no Fix for "AzureDataExplorer.Contents" statement is in sight now. However 😞

    Best regards,

    Christian

Christian_Heinz's avatar
Christian_Heinz
Icon for Helper I rankHelper I
5 years ago

Hi Robert,

thank you for your response. 

I cannot see any limitations in that article which affects the issue I reported. 

I will create a minimal report with one simple ADX query to reproduce that issue and upload the file here for further investigation. Makes that sense?

Best regards,

Christian

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Christian_Heinz 

To deal with cases related to issues in Power BI, I suggest you to go to the Power BI community Issue Forum to suggest a new idea so that our members will test and check if it’s necessary to submit this issue to ICM and update the bug fix time in time.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Christian_Heinz's avatar
    Christian_Heinz
    Icon for Helper I rankHelper I
    5 years ago

    Hi,

    here a short update: After I posted that issue to the ideas forum, i got a suggestion to change "AzureDataExplorer.Contents" to the legacy mode "Kusto.Contents" which solved that problem.

    Here my complete (fixed) query script:

    let
    Quelle = Kusto.Contents(EnvironementSwitchADX, null, null, null),
    public = Quelle{[Name="public"]}[Data],
    PUB_TSM_FN_Issues1 = public{[Name="PUB_TSM_FN_Issues"]}[Data]
    in
    PUB_TSM_FN_Issues1

    Unfortunately, my idea request was removed. So no Fix for "AzureDataExplorer.Contents" statement is in sight now. However 😞

    Best regards,

    Christian