Power BI

Under Review

Allow schema refresh for SQL Azure Direct Connect

Vote (130)

John Rampono on 23 Jun 2015 20:04:51

Administrator on 13 May 2016 02:08:44

Hi everyone, You should check out Direct Query in Power BI Desktop, it doesn't have the same restrictions as the experience in the service. You can build your reports in Desktop and publish them to the service! Here's more details: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

Comments (18)

Comments (18)

Power BI User on 05 Jul 2020 22:15:33

RE: Allow schema refresh for SQL Azure Direct Connect

How is this not in there?

Graham Ross on 05 Jul 2020 22:14:21

RE: Allow schema refresh for SQL Azure Direct Connect

This, I would have thought, would be an absolute requirement. I am writing new views all of the time and to keep starting my reports from scratch is ridiculous!

Power BI User on 05 Jul 2020 22:11:18

RE: Allow schema refresh for SQL Azure Direct Connect

Yes please

Power BI User on 05 Jul 2020 22:09:10

RE: Allow schema refresh for SQL Azure Direct Connect

Much needed functionality

William Xie on 05 Jul 2020 22:04:24

RE: Allow schema refresh for SQL Azure Direct Connect

In addition to updating the Schema for a given table/view, can we update if new Tables/Views are created or old Tables/Views are deleted as well?

Mark Fermor on 05 Jul 2020 22:03:35

RE: Allow schema refresh for SQL Azure Direct Connect

For Power BI not to refresh schema from Azure SQL is pretty scary.

Marty on 05 Jul 2020 22:02:38

RE: Allow schema refresh for SQL Azure Direct Connect

I'm amazed there is no ability to do this now. I want to be able to add a view to a set of reports without deleting and re-attaching the entire dataset.

Casey on 05 Jul 2020 22:02:28

RE: Allow schema refresh for SQL Azure Direct Connect

I am not sure why this isn't there already. As of now it seems I have to delete a data source and re-add it in order to update the schema.