Where did all my tables go?Īfter posting this “issue” on Microsoft’s Yammer site, we got an answer basically saying – it is what it is, and I should use Expressions. If you are used to Power BI or Power Pivot, you would expect all your tables to show up, but you will only see the single table that you requested the Table Properties for. ![]() The Query Editor screen seems peculiar, however. Click on the Design button, which will launch the Query Editor screen.If you want to get back to Query Editor within Visual Studio, the only way that I have found so far is to Now, there are some differences when working on Query Editor within Visual Studio and Power BI / Power Pivot, however, and I’d like to discuss the biggest difference I saw:Īll of your queries do not show up in the Query Editor! Let me explain what that means:Īs an example, below image shows 5 tables in a model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. ![]() Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |