database connection
3 TopicsPower BI reading measures from the database in import mode?
Hello everyone! I'm interested in finding out if it's possible to reuse already calculated (dynamic) measures in a data mart on a database that is defined on a semantic layer (for example, dbt). Is it possible to use such a scenario with the import function when direct query is not possible? It's somewhat similar to querying an SSAS tabular cube in live mode, but here we are discussing some column store databases from third-party vendors (where live direct query isn't possible). I would like to avoid calculating measures in Power BI; therefore, the question.1.1KViews0likes3CommentsReport Builder Connection To Database Drop Down Is Blank
Hello, I am trying to connect my report builder to my PBI dataset/database. I right clicked on datasources - add data source, and used Microsoft SQL Server Analysis Services, then copied the server settings connection link (that is associated with my dataset) into the connection properties. I have logged in when it asked me to. Then when I go to the drop down window under connect to a database - my database does not show up. Can you help?Solved802Views0likes3Comments