When I connect Power Query to a PostgreSQL database I get a list of tables and views in the database. But materialized views are not shown. I would suggest that Power Query would be able to connect t...
sunder-nagaraja
6 years agoRegular Visitor
A nice workaround is to create a view in PostgreSQL for the materialized view. Worked wonders. Indexed views in SQL server do not allow for remote access. Hopefully SQL server 2016 may have those features available.
Recent ideas
Restore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch2 hours agoNew MemberNew9Views1like0CommentsRestore "no-reply" option for Power BI Subscriptions
Please add a setting in the Power BI Subscription pane to choose the sender identity. With the recent update the platform forces emails to route through the subscription owner's personal Exchange On...LenaFid3 hours agoRegular VisitorNew194Views32likes8CommentsWhen adding a datasource to a gateway, allow the 60 second timeout to be changed
When adding a datasource from my on-premise MySQL database, Power Bi will send a query to my Information.Schema table that can take over 60 seconds to query (depending on the database). Since it keep...jfenico13 hours agoNew MemberNeeds Votes182Views6likes3CommentsAllow Power BI subscriptions to use a no-reply sender instead of the subscription owner's mailbox
Following the migration to the new email delivery platform, subscription emails now appear to come from the subscription owner. This generates large volumes of Out of Office replies, auto-replies, an...tm824 hours agoNew MemberNew28Views8likes1Comment