Forum Discussion
New tables not updating in datasets from Azure SQL Data Warehouse
Hi, I'm facing problem in refreshing datasets that are from Azure sql data warehouse. I'm able to see the data up to date, but when new tables added to the db. I'm not able to see new tables in datasets. I tried to refresh dataset multiple times still no luck.
Could you please help me to figure it out?
Sundar1606,
Do you refresh the dataset in Power BI Service? Refresh in Power BI Service is data refresh, when you add new tables in the database, you would need to import the new tables to Power BI Desktop, then republish the Power BI Desktop file to Power BI Service.
Regards,
LydiaSundar1606,
When you add new tables in the same database, you are able to import data of the new tables into the current PBIX file even you use DirectQuery mode to connect to Azure SQL data warehouse.
Regards,Lydia
8 Replies
Sundar1606 The dataset contains only the objects that existed when you initially connected to the dataset. I have found no way to pull the additional tables in when connecting via direct query. This includes the Service as well as the Desktop. While you can see and connect to the new table in edit queries, it does not allow you to includes the new table without errors being thrown...
Oh, thank you. I understand now. When we add new tables to db or modified a table, we should add new direct query connection and then, built a report from start ? Oops! this could be additional work.
In your original report, what option do you use to connect to Azure SQL data warehouse, directquery or import?
Regards,
Lydia
Sundar1606,
Do you refresh the dataset in Power BI Service? Refresh in Power BI Service is data refresh, when you add new tables in the database, you would need to import the new tables to Power BI Desktop, then republish the Power BI Desktop file to Power BI Service.
Regards,
LydiaSundar1606Anonymous I should have clarified my response as well. Using the Import connection, there is no issue if you use the Desktop. If you use Direct Query in the Desktop or just connect from the Service you will run into problems as you can't add the extra tables. I understand the limitation in the Service, but I'm a bit confused as to why it isn't allowed in the Desktop for Direct Query.
