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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

direct query from sqlserver not working for licenced user

Dear Comunity,

 

I have an interesting and kinda ridiculous problem:

 

I made some reports within 60 days period which are all using direct query, I set up the schedule refresh and they still work fine. (I was using my gmail account)
BUT after I start using my licenced pro user, I tried to publish the same reports. In desktop environment all seems fine, when I publish the report, report shows the recently updated data but data source credentials greyed out and also scheduled refresh greyed out.

I use PBI Desktop Version: 2.76.5678.782 64-bit

What may cause this behaviour? And how can I fix this?
you may see the screenshots of both users below:

Free user:

pbi_free_user_datasets_data_source_credentials.png

 

Licenced User:
licanced_user_dataset_data_source_credentials_grayed_out.png

 

licanced_user_dataset_scheduled_refresh_grayed_out.png

5 REPLIES 5
parry2k
Super User
Super User

@Anonymous where is db? Is it in cloud or on-prem? Are you using gateway? If yes, personal or enterprise?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

@parry2k it is on-premise, I am not using gateway, only direct query.

@Anonymous  is it personal or enterprise gateway? if you expand gateway section , what do you see? I think thats where the issue is?

 


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

it says personal gateway...

 

pbi_free_user_gateway_personal.png

Anonymous
Not applicable

btw with free user that shows personal gateway; when I select Settings\Manage Gataways it shows:

 

pbi_free_user_manage_gateways.png

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.