Forum Discussion
Direct query instead of mixed mode - refresh question
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,
What are the data sources in your dataset? Please go to File->Options and Settings-> Data source Settings in Power BI Desktop to check all data sources and post a screenshot about them.
In Power BI Desktop, it doesn't support DirectQuery mode for NAV data source,please check all the data sources supported by DirectQuery in this article.
In addition, when you have mix storage mode in the PBIX file, you are limited to refresh 8 times a day in Power BI Service unless you have Power BI premium license. Only when you have direct query /connect live mode in the PBIX file, you can refresh the dataset every half an hour.
Regards,
Lydia
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?
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
