Using DirectQuery while entering more data in new table

[hellgoingon]

Hi all,

I'm connecting to SQL Server and use DirectQuery mode. But workss requires to have more tables (But I do not have permission to add more table in SQL server) so i create new tables in Power BI by entering data.

The problem is: When entering data in new table (in PowerBI), DirectQuery mode will be disable and changed to import mode.

The question is: How can i enter more data into PowerBI and keep DirectQuery mode?

[graxxon]

Hello.

I have a direct query report where I added the additional static or yearly changing content in Oracle PL SQL,

not the easiest solution, but it works.

Oracle PL SQL sample:

SELECT '100001' as "Group", 'Something 1' as "Line", 'AB' as "VS", 6.903 as "2017", 4.256 as "2018", 6.354 as "2019", null as "2020", null as "2021", null as "2022", null as "2023", null as "2024", null as "2025" FROM DUAL UNION ALL

-- Group Line VS 2017 2018 2019 2020 2021 2022 2023 2024 2025 VALUES
SELECT '100002', 'Something 2', 'AB', 9.571, 7.632, 9.437, 2.656, 8.999, null, null, null, null FROM DUAL UNION ALL
SELECT '100003', 'Something 3', 'AB', 9.571, 7.632, 9.437, 2.656, 8.999, null, null, null, null FROM DUAL UNION ALL
SELECT '100004', 'Something 4', 'AB', null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100015', 'Something 5', 'CD', 8.921, 2.689, 9.753, 9.791, 5.911, null, null, null, null FROM DUAL UNION ALL
SELECT '100016', 'Something 6', null, null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100017', 'Something 7', 'AB', 9.664, 3.385, 3.881, 2.305, 5.200, null, null, null, null FROM DUAL UNION ALL
SELECT '100018', 'Something 8', 'CD', null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100016', 'Something 9', 'DE', null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100019', 'Something 10', 'DE', 0.348, 5.743, 4.416, 3.228, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100020', 'Something 11', 'AB', null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100021', 'Something 12', 'CD', null, null, null, null, null, null, null, null, null FROM DUAL UNION ALL
SELECT '100022', 'Something 13', 'AB', 0.705, 9.003, 9.865, 2.025, 3.443, null, null, null, null FROM DUAL UNION ALL
SELECT null, ' ', null, null, null, null, null, null, null, null, null, null FROM DUAL

[v-sihou-msft]

@hellgoingon

No, it's not possible. When using DirectQuery mode, all tables must be from same source (the SQL database in this scenario). You have to create the new tables on database.

Regards,

[hellgoingon]

Thanks for replying