Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
5 years ago

Ive been testing the updates for Direct Query for Power BI datasets and Analysis Services in Preview at the moment

 

Previously there were three issues

 

Connect to Dataset 1 and data set 2.

the folders created within data set 1 and 2 are not in the reporting pbix file (This is now resolved)

The Sort by on fields have been lost in the reporting pbix file (This has now been resolved)

The formatting is lost on data sets.

This unfortunately still seems to be a problem and we absolutely dont want to lose the formatting work set within the data sets

 

 

In the dataset this is Percentage 2 for one of my measures, however in the reporting pbix file the formatting hasnt come through

 

So unfortuantely for us this still isnt fit for purpose. Has anyone else noticed this?

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    as noted in the blog formatting is not yet persisted. It will be though.

    • LukeSteen's avatar
      LukeSteen
      Frequent Visitor
      5 years ago

      Was this addressed in the June update?  Based on the blog I thought it was, but I am still not seeing formatting on my measures flow from the original model to the one with the DirectQuery. 

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Icon for Microsoft Employee rankMicrosoft Employee
        5 years ago

        it should have. If it's not, please open an issue.