Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi there, I'm trying to use this feature when connecting to a Power BI dataset sourcing data from an Excel file. The Excel file contains data sourced from a database using Power Query and loaded to a pivot table. I then publish the Excel file to the Power BI server making its underlying data available as a Power BI dataset. I've updated my Power BI desktop to the latest version and enabled this previous feature. However, when I connect to this Power BI dataset, the only option that is available under the "Get data" section is "Power BI template Apps". I am also not allowed to "Make changes to this model" as your screenshot showed. This is a great feature and we'd love to use it in our future reporting. But I'm not sure if I've missed anything here. Any suggestions?
Microsoft EmployeeHi, you mentioned 'Power BI Server', are you referring to Power BI Report Server? This feature is not available there. Also, please make sure your dataset that access the Excel file can successfully be refreshed. Does anything change if you import the Excel file into the dataset?