I want to publish my power bi desktop reports?

Question

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.

Answer 1

Hi @Fatima Ismail ,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Best regards,
Leon