Query Editor Data Source

[Anonymous]

Hi,

If i want to add a new query and the source that i want is All the tables that already exist in the power bi. 
How should be the query to get all tables that already existi in power bi because I did some modification on them and I dont want them to get the source from SQL Server. 
Beside that I've imported that data as IMPORT not Direct.

[Greg_Deckler · Accepted solution]

Publish your PBIX to the Service.

Make sure you turn on the Preview feature for connecting to Power BI Service as a data source.

Create a new PBIX and connect to your dataset in Power BI Service.

[Anonymous]

This could work but still not local

[Greg_Deckler]

There is a technique for connecting to the local SSAS instance for an open PBIX file. That might also get you there.

https://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/

[lindameans]

If you find please let me know