Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
This is a brilliant enhancement with huge potential value - thank you.
Note however, preview testing I have an issue in desktop importing a PBI dataset into a simple existing local model (i.e. composite model) where the table relationships from this "live connection" dataset were lost when using this method importing as direct query. The imported PBI dataset tables are all shown in the Model view and data can be obtained from each individually - however these tables have no relationships and neither can the original relationships be re-added, so the dataset model cannot really be used.
I'm not sure this is due to the nature of the preview version, a current table limitation or something I am doing incorrectly - does anyone have any suggestions?