Shapefiles
I am not sure if this is the right section of the forum to be asking this, but I am trying to get a Shape Map in PowerBi using shapefiles. I have tried numerous times and watched many videos but cannot seem to figure out how ot upload my shp file (and other files) to powerBi and get them to fully load in the Shape Map. I have also installed the shape map visual to my PowerBi. I am trying to get a colored shape map of the US cenus data -- so I have the excel data for population (example) and now i want to use the US census tract data as the map for showing a heat map for population in each city/county based of its geoid or code. If anyone has any tips let me know!
File and database via gateway on a Windows AWS Server
Hello everyone, I spent a week trying to connect a cloud report with the data in an AWS EC2 instance with a Windows server. My sources of data are a Microsoft SQL server in another machine and some excel and CSV files. My SQL server is running in another machine and can be reached via an internal AWS network and with the respective security group configuration. I could expose/"connect with the app" to the SQL server via a gateway install in my Windows server. I also have the files in the server but I can't expose them via the gateway, showing me bad credentials when I try to add them as files new data source. I also tried to upload and share via one drive, but I couldn't link the files via sharepoint. I hope someone could help me. Regards,