Tutorial to Create a Power BI Report Using PostgreSQL

Question

Post reply

Tutorial to Create a Power BI Report Using PostgreSQL

Daniel Calbimonte

SSCertifiable

Points: 6063
More actions
November 14, 2022 at 12:00 am

#4105484

Comments posted to this topic are about the item Tutorial to Create a Power BI Report Using PostgreSQL

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Robert Sterbal SSChampion Points: 11047 More actions · Answer 1

What would you recommend for learning more about indexing in Postgrsql?

Thanks for the installation walk through. It will save some time the next time I have to install.

412-977-3526 call/text

Jeff Moden SSC Guru Points: 1003867 More actions · Answer 2

Robert Sterbal wrote:

What would you recommend for learning more about indexing in Postgrsql?

Perhaps the documentation? 😉 https://www.postgresql.org/docs/current/indexes.html

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

pietlinden SSC Guru Points: 63428 More actions · Answer 3

In other words, once you've connected, it's pretty much the same as working with a SQL Server database?

If I can execute a stored procedure in PostGreSQL, I assume I can just connect and use the query window to call the stored procedure. Right?

Robert Sterbal SSChampion Points: 11047 More actions · Answer 4

Thanks.

For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.

Right now most of my queries are 45 seconds. This should speed things up a bit.

412-977-3526 call/text

Jeff Moden SSC Guru Points: 1003867 More actions · Answer 5

Robert Sterbal wrote:

Thanks.
For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.

To be honest, that sounds like a PII violation on the part of the keystone state. 🙁

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Robert Sterbal-482516 SSCrazy Points: 2870 More actions · Answer 6

---------- Forwarded message ---------

From: ST, Elections <RA-Elections@pa.gov>

Date: Tue, Sep 6, 2022 at 3:28 PM

Subject: Re: [External] Creating a list of related political districts

To: Robert Sterbal

You would be able to publish that list of political subdivisions that belong to Congressional Districts.

From: Robert Sterbal

Sent: Monday, August 29, 2022 7:25 PM

To: ST, Elections <RA-Elections@pa.gov>

Subject: [External] Creating a list of related political districts

ATTENTION: This email message is from an external sender. Do not open links or attachments from unknown senders. To report suspicious email, use the Report Phishing button in Outlook.

I'm looking to create a spreadsheet that shows all the political subdivisions of each of the 17 Congressional districts in the state.

One way of doing this is to use the PA Voter Export and filter the distinct political districts for each county.

Would I be able to publish the resulting list on the internet?

Thanks,

--Robert Sterbal

robert@sterbal.com

412-977-3526

Mosaics by Robert: https://www.facebook.com/groups/1783957901820381/ (for a fun distraction)

Jeff Moden SSC Guru Points: 1003867 More actions · Answer 7

Will the real Robert Sterbal please stand up?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Robert Sterbal-482516 SSCrazy Points: 2870 More actions · Answer 8

Learning about indexes is work related.

Letters to the state government are my own.