Comments (2)
fmms
commented on June 10, 2024
Ok, I have isolated the problem. The reason is the type of data source. To my understanding MSOLEDBSQL is the preferred way of connecting a Tabular Model (SSAS, AS, Power BI Premium) to a SQL Server. IN my testing this is the fastest way to connect onPrem too SQL Server.
However, it seems the Power BI service cannot handle ProviderDataSource with anything but System.Data.SqlClient.
However, reading https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/ I am not sure if using System.Data.SqlClient is the best option for the future.
| Power Query | MSOLEDBSQL |
System.Data.SqlClient |
Microsoft.Data.SqlClient |
|
|---|---|---|---|---|
| SSAS 2019 | 23m 12s | 22m 37s | 32m 10s | Error returned: 'The managed provider 'Microsoft.Data.SqlClient' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed. A connection could not be made to the data source with the Name of 'DWH'.'. |
| Power BI | 1h 15m 54s | {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"An unexpected internal error happened while obtaining the credentials for the data source '<ccon>13</ccon>': data source information is not found in Power BI service."}}]}}} |
1h 16m 48s | {"error":{"code":"DM_GWPipeline_Gateway_FeatureNotSupported","pbi.error":{"code":"DM_GWPipeline_Gateway_FeatureNotSupported","parameters":{},"details":[],"exceptionCulprit":1}}} Table: fact_xxx. |
Can anyone else share their experiences and their guidance which kind of connection string to use with Power BI Premium?
from tabulareditor.
otykier
commented on June 10, 2024
The only way I've ever gotten SQL-based ProviderDataSources to work in a model hosted within the Power BI Service, is to set up the data source exactly as specified in this TMSL example on the official docs. That is, SQLNCLI11 as the provider, and the following annotation on the data source:
| Name | Value |
|---|---|
| ConnectionEditUISource | SqlServer |
Hope this helps!
from tabulareditor.
Related Issues (20)
- Unable to add fields in the Value section of Matrix after adding Calculation Group HOT 3
- Export BPA results HOT 5
- CLI - Save as TMDL HOT 2
- Importing from Fabric Warehouse HOT 1
- Power BI Desktop can't open TMDL from TE: Parsing error type - InvalidLineType HOT 2
- DataCoverageDefinition not taken into account. Tabular Editor fails to connect after deploying model. HOT 2
- 'Access Denied' Error saving TMDL structure back to original source folder HOT 2
- Integration of OpenAI for DAX calculations HOT 6
- DataCoverageDefinition Evaluation Error HOT 6
- Loading model.tmdl from command line results in "Connection string is not valid" HOT 3
- Ordering of tables in model.tmdl HOT 7
- BPA with Azure Function HOT 1
- GetAnnotation shows twice in tooltips on a column HOT 2
- BPA Rule to validate RLS HOT 4
- TMDL models not shown in recent models
- database.tmdl not shown when opening model file
- For TMDL model SerilizationOptions annotation includes "Levels"
- Removing column which has translation/perspective
- Tabular Editor2 - Preferences - Collect Telemetry - Control option HOT 5
- Tabular Editor 2.X in Release Mode
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tabulareditor.