Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Allow schema refresh for SQL Azure Direct Connect

Allow schema refresh for SQL Azure Direct Connect
Status: Under Review
Comments
nishalit
New Member
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/
casey_pettingil
New Member
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.
mhenning
Advocate I
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.
mf4
New Member
For Power BI not to refresh schema from Azure SQL is pretty scary.
willixie
New Member
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?
fbcideas_migusr
New Member
Much needed functionality
mw1
New Member
Yes please
gjross
Advocate II
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!
stephan6
New Member
How is this not in there?
marc_weldon
New Member
I'm shocked this isn't built in - do I have to delete my data source and all my reports if I add or update a view??!