Forum Discussion

Sundar1606's avatar
Sundar1606
Helper I
8 years ago
Solved

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 datas...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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,
    Lydia

  • Anonymous's avatar
    Anonymous
    8 years ago

    Sundar1606,

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Sundar1606Anonymous 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.