How can we improve Power BI?

Combine DirectQuery from Database with Imported Files

It would be extremely helpful to be able to have a DirectQuery to my SQL Server stay live while still allowing me to import files (Excel in particular) so that I can fill in some blanks much easier even if the data is separated somewhere on the server or if I am trying to add another layer of data that isn't on the server. Right now we can only do with by changing to Import and lose the DirectQuery connection I want to keep.

Ready to get started?

Power BI Newsletter

Take your data to the next level with the best tips and tricks from our experts.

Thanks for signing up for the Power BI newsletter.

By clicking Sign up, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time.

Downloads

Whether you are on the go or need to create rich, interactive reports, Power BI offers you the tools you need.