We have a requirements that we need to create Dataflow on SQL Analysis Server.
we can connect SQL analysis server through power bi desktop, but when i tried to create Dataflow on SQL Analysis server i do not see the option, as you see the below screenshots?
what is the best recommended approach to create Dataflows on SQL Analysis Server databases affectively?
how can i achieve this?
Thanks for your inputs.
The requirement is that Business is already created Cube in SQL Analysis server on top of tables and created around 70 KPIs after hectic efforts and the Reports already up and running in Tableau, and now they want to swith reporting tool to Power BI and start creating reports.
Business asking to use Cube with Live connection because already KPIs are readily available.
We are in a direction to use Dataflows with Schedule refresh/Incremental Refresh.
We want to propose below options.
Connect Analysis server Tables through Power bi desktop and create Dataflow using Blank query - Time consuming due to KPIs recreation
Connect directly the Model using Direct connection and create Dataflow using Blank query - Live connection performance bad ?
any best practices and recommendations please?
I am also trying to access on-prem AS datasources with dataflows.
There are many use cases for this. One that we have is that we need the same tables to be reused in several datasets and we do not want to maintain the query in several datasets.
I am the DMG admin.
When I copy the query developped in Power BI Desktop to a dataflow, I am requested to select a DMG, and even though the data source is defined, I am prompted to provide the credentials for the AS data source. But when I do so, I get the following error: "Received error payload from gateway service with ID xxxx: Internal error: MashupCredential for AS data source that uses Windows authentication needs to have an effective user name authentication property"
But I do not see any way of providing this parameter.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.