Forum Discussion

2ccccc's avatar
2ccccc
Frequent Visitor
6 years ago

Data doesn't get updated by direct query report

I have a report, data connection type is mixed(all tables is direct query except I create a data table by using DAX). Data is from my Azure SQL Database. After I finished it, I published it to my pub...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

Can you confirm that your table from Azure SQL Database is in DirectQuery?

You can click on the table in Power BI Desktop, then right click and select Properties.

What does the storage mode say?
2ccccc's avatar
2ccccc
Frequent Visitor
6 years ago

Hi GilbertQ Yes. The table from Azure SQL DB storage mode is DirectQuery.