mlonsk
commented
5 months ago Hi @bhavana-donaparthi
In your old AAS model you used explicit or legacy data sources which you have migrated into Power BI, but models created in Power BI Desktop use so called implicit data sources, that is the data source is specified through M expressions inside each table partition.
This is generally the best way to handle data source connections in Power BI, as this allows the Power BI service to handle credentials and connections and opens up all the different connectors Power BI has.
You can create shared expressions that are then parameters in the partition.
An example could look like this:
In your case this is what I would use to implement to connection to Dremio
Another recommended way is use Structured datasources where you can convert your legacy data sources with a script as described here: https://www.elegantbi.com/post/convertdatasources This could also be an option for you and define the data source to Dremio therein, but I have little experience with this form of migration. to give any advice.
For more details regarding importing tables using Tabular Editor 2 you can check out this documentation: https://docs.tabulareditor.com/te2/Importing-Tables.html
What are you trying to achieve? Hi Team, We recently migrated our AAS (Azure Analysis Services) model to Power BI using Tabular Editor by following the steps provided in the https://data-marc.com/2020/06/16/migrate-analysis-services-models-to-power-bi-using-tabular-editor/
Post successful migration, using Tabular Editor we changed the data source (Azure SQL Server) connection details from dev to prod. Now, I would like to change my data source connection to Dremio. I am finding it difficult to understand how can I create a data source in tabular editor for my migrated model as there are so many properties involved. Post having a successful data source created and tested, I would like to change the data source of my migrated semantic model (tables) from SQL server to Dremio.
What have you tried so far? Initially I created a simple report in Power BI Desktop with Dremio as my Data source and published it to Power BI workspace. Later, opened that semantic model of report (semantic model got created when report was published) in Tabular Editor and tried to check but there is no data source. Under Partition I can see that Source is coming as Dremio and other details like Source{[Name, Kind]} and then Schema{[Name, View]}. Using the Source values I tried to create Data source with Dremio by providing Server and Schema properties and later opened it in Power BI. But I see that under settings of this model in PowerBI, Data source credentials option is greyed out (which earlier was enabled when I published report from Power BI Desktop using Dremio Data source).
I would like to avoid the re-work of building semantic model again. Hence, trying to understand if this small manual work is possible.