I am working on power bi desktop for visualizations. I have SQL server dataset which is on my local machine. I have connected the Data using import connection mode of power bi and loaded the data set into my power bi desktop. I have installed gateway to make connection of my on premises dataset to the power bi service. I have successfully made the connection as well. But when I come to publish my reports It never gets published (taking ages to publish) and just keeps loading for hours that will get published but they never get published. When I connect the dataset using Query mode connection the reports get published but I cannot further create calculated tables and play with measures and columns effectively. While in Import connection mode I can do everything except publishing my reports. Please provide me some solution to this. I really need help please.