I'm not able to publish my report

[Hadill]

Hi there,

I am trying to find a way to certain a schaduled refresh for my report. 

I am using import option to get the data from SQL server to the PBI disktop, but the option is unavailable on the PBI service when i publish it.

Is there any suggestions? advices?

Thanks a lot in advance!

[gauthamboppana · Accepted solution]

Hey @Hadill  - Are you using SQL On Prem or Azure SQL?  Please check if you have any other datasources (in Power BI Desktop > Go to Data Source Settings). 

Also, try setting up the privacy levels to Organizational in Power BI desktop. Publish the pbix to PBI Service and make sure to updated Privacy on dataset on Power BI Service as well i.e.  Dataset Setting –> Data Source Credentials -> Edit Credentials -> Make sure to use credentials with same Auth/Privacy as in PBI Desktop -> OK).

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !