Forum Discussion
dylanndengu
5 years agoHelper I
DAX Equations with DirectQuery
Hi Everyone, I am using DirectQuery to access data in a PostgreSQL database with millions of rows. I'm accessing about 10 different tables and trying to make reports using them. One of them is cu...
amitchandak
5 years agoSuper User
dylanndengu , I see a space above and I see a _ below after public
Also not all column operation are supported on direct query
dylanndengu
5 years agoHelper I
Hi again amitchandak, noted the change but I still can't access the table for DAX calculations. Alternatively, would you have any suggestion as to how I could import the data into Power BI quickly? Because it takes at least 2 hours or so to import all the data from PostgreSQL. Even after it is imported, it then can take an hour to refresh the next day.