Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
On our Postgres server, I cannot connect to any of the tables. I can see the tables but cannot access them. In the power query editor, I can refresh the existing queries, but I cannot add any additional table to the query.
Any help would be appreciated.
Thank You
Solved! Go to Solution.
In the desktop version I can change the data and shape it. I can duplicate a table, change the source, and identify the source as a new table in the list. This allows me to add the information, but it's a strange way to be able to access the data.
I do not see this was solved. I am having a similar issue however sometime (while chnaging nothing else) I can refresh my data. Please help!
My development team has checked it and they can see the connection, but cannot figure out why it won't allow me to query the data table.
@SafetyEv weird, can you try with any other tool to see if you can perform select statements on these tables?
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.
In the desktop version I can change the data and shape it. I can duplicate a table, change the source, and identify the source as a new table in the list. This allows me to add the information, but it's a strange way to be able to access the data.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |