Forum Discussion

SebastianMaenz's avatar
SebastianMaenz
Frequent Visitor
6 years ago

Measure Issue: works flawless using import query but fails using direct query???

Hi,   this measure gives me the correct result when used in desktop version (via import query AND direct query) but works only in the online service when using import query. The result is [NULL] us...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi SebastianMaenz ,

Please download your PBIX file from Power BI Service and open with Power BI Desktop. Check if there is any difference. Maybe your data has been refreshed and the result is just NULL.

 

Best Regards,

Icey

 

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

SebastianMaenz's avatar
SebastianMaenz
Frequent Visitor
6 years ago

Hi,

 

I have already tried it out within one report using 2 identical measures. One is referenced to the datasource via direct query the other one via import query. Only the latter will show the correct result. 

 

...very frustrating 😒

 

Best regards,

Sebastian

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi SebastianMaenz ,

    That's so strange. If you are a Pro user, not trial, I suggest you to create a support ticket to get further help.

     

     

    Best Regards,

    Icey

     

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