topic Re: Unable to design query in report builder in Report Server

Unable to design query in report builder

Anonymous — Tue, 06 Sep 2022 19:42:12 GMT

Hello again,

I have been following along with the "Paginated Reports in a Day" YouTube series: https://www.youtube.com/watch?v=13-6sWIRD74&list=PL1N57mwBHtN1icIhpjQOaRL8r9G-wytpT&index=13. I am currently on Lab 4A, which is described in the above video and on this PDF: PowerBIPRIAD_Lab04A.pdf

This time I am unable to access the Query Designer function in the Dataset Properties box. I should note that I was able to do this earlier today. I successfully followed along with the video until I reached Task 1, direction 24 to Run (at 4:28 in the video), but when I hit the button, the program showed me only a list of the last few names on my list and then froze up. I had no choice but to close the program and restart from the beginning of the lab. And now when I try to open the Query Designer, it doesn't work at all because it is requesting my login credentials. When I type in my login credentials, it returns the following error message:

When I click on Details >>, it just says "Login failed for user 'myusername'. (I replaced my actual username with myusername for privacy reasons)

What the heck happened? It worked perfectly the first time, and I did not need to enter any credentials.

Re: Unable to design query in report builder

v-luwang-msft — Wed, 07 Sep 2022 06:22:27 GMT

Hi Anonymous ,

What is the data source and how do you connect to it?

See if these will help:
https://community.powerbi.com/t5/Power-Query/ODBC-Connection-Error-Driver-Error/td-p/163517
https://whitepages.unlimitedviz.com/2019/10/fixing-power-bi-report-builder-connection-errors/

Best Regards

Lucien

Re: Unable to design query in report builder

Anonymous — Wed, 07 Sep 2022 13:40:00 GMT

To find the data source, go to this link (from the video descriptions on YouTube). Scroll down to Attendee Kit. Then click where it says "this link" to download the folder, and unzip it. This post is specifically about Lab 04A (which is completed in video 13 in the playlist linked above). To start Lab 04A, open the Solution file from the Lab 03A folder and the directions file in the Lab 04A folder labeled "PowerBIPRIAD_Lab04A".