Forum Discussion

Christian_Heinz's avatar
Christian_Heinz
Helper 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

v-robertq-msft's avatar
v-robertq-msft
Community 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
Helper 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