cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ghouse_peer
Post Patron
Post Patron

Publishing reports from power bi report builder without connecting to database

Hi Team

 

Few days back i have logged in into power bi report builder tool and setup the database. Logged in into datasource and setup the query. After successfull execution i got respective fields in left pane. I did drag and drop in table visual.

Later run the query and was successfull. I saved it.

 

Today when i opened the same file and followed all the steps except Logging into Datasource.( I have not logged in into Datasource).

Published the report to power bi service.

When i tried to open the published report in power bi service i am getting error like "cannot connect to underlying dataset, make sure credentials are correct".

 Kindly let me know what is the reason for getting this error.

Is there any step which i have missed or should be followed. 

Please help.

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @ghouse_peer ,

 

If the paginated report data source is on premises, then it is needed to create or connect to a gateway to access the data.

 

Not connect to a gateway:

 

no gateway 2.PNG

 

Connect to a gateway:

 

gateway - rdl.PNG

 

Reference: Publish a paginated report to the Power BI service # Connect to a gateway

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @ghouse_peer ,

 

If the paginated report data source is on premises, then it is needed to create or connect to a gateway to access the data.

 

Not connect to a gateway:

 

no gateway 2.PNG

 

Connect to a gateway:

 

gateway - rdl.PNG

 

Reference: Publish a paginated report to the Power BI service # Connect to a gateway

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Icey. This solution helped me..

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.