Forum Discussion

maya13's avatar
maya13
Regular Visitor
7 years ago
Solved

Direct query instead of mixed mode - refresh question

Hi All,   I would like my report to refresh automatically when published into Power BI workspace. As I understand it correctly only direct queries datasets can be refreshed automatically (assuming ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    maya13,

    You would need to create the calendar table in Azure SQL database which you use DirectQuery mode. This way, import the calendar table in Power BI Desktop, you can keep live mode as you describe.

    Regards,
    Lydia

maya13's avatar
maya13
Regular Visitor
7 years ago

Hi Lydia,

 

The data source is our sever that is in Azure, sorry I was not clear enough before. So basically all data is in Azure except for if the date table. Is there any date table/calendar (built into power BI) that I can use to keep the direct query format of my report and to be able to refresh live. How do you overcome the issue of the calendar table?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

maya13,

You would need to create the calendar table in Azure SQL database which you use DirectQuery mode. This way, import the calendar table in Power BI Desktop, you can keep live mode as you describe.

Regards,
Lydia