Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Import mode fonts and DirectQuery

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 othe...
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    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.