Import mode fonts and DirectQuery

[Syndicate_Admin]

Good afternoon.

I have to put together a report where certain data is obtained through a query about the Data Warehouse that is found in Azure SQL Server using the import mode (table A). The other part of the data is obtained through a query on the basis of the transactional system that is in Oracle using directQuery mode (Table B).

Both tables have the same structure. Example:

Table 1

Group	Indicator	Guy	Matter
Group 1	Indicator 1	Type 1	Matter
Group 1	Indicator 2	Type 1	Matter
Group 1	Indicator 3	Type 2	Matter

Table 2

Group	Indicator	Guy	Matter
Group 2	Indicator 4	Type 1	Matter
Group 2	Indicator 5	Type 1	Matter
Group 2	Indicator 6	Type 2	Matter

In the report I have to show the data from both tables in an array. Example:

Group	Guy	Indicator	Matter
Group 1	Type 1	Indicator 1	Matter
Group 1	Type 1	Indicator 2	Matter
Group 1	Type 2	Indicator 3	Matter
Group 2	Type 1	Indicator 4	Matter
Group 2	Type 1	Indicator 5	Matter
Group 2	Type 2	Indicator 6	Matter

In order to assemble the matrix as I indicate, I used in Power Query Editor the functionality of combining --> Append Queries as New. I call the new table Table. This new table is import mode.

I put together the report using the data contained in Table and publish it. I set the update schedule to run twice a day so that I can update table1.

When I update the report using the button I see in the screenshot, it does not update the online data that corresponds to table 2.

They know how I can get the data updated d

[v-xiaotang]

Hi @Syndicate_Admin 

Thanks for reaching out to us.

>> The other part of the data is obtained through a query on the basis of the transactional system that is in Oracle using directQuery mode (Table B).

When I update the report using the button I see in the screenshot, it does not update the online data that corresponds to table 2.

Do you mean, when you click refresh button, tableA will refresh, but tableB and New table won't refresh?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Good morning.

With the scheduled update running twice a day, all three tables are updated (Table A --> import mode, Table B --> QueryDirect mode, and Table --> Combination of Table A and Table B that is created in import mode). This is fine.

What I need is for Table A to be updated twice a day using scheduled updates (this is done correctly), Table B to be updated online every time the button marked in the screenshot is pressed (this is done correctly) and table (joining Table A and Table B by combining in Power Query Editor) is also updated with table A data that has been imported. through programming and Table B with online data.

Best regards.