User Profile
thiagogouveiar
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
- 971Views0likes0Comments
Error to refresh data - No Message
Hello everyone, I've a problem and I don't know how can I handle with that. I'm trying to refresh my dataset in Power BI Service and I getting the error as follow: I don't know how can I handle with that because there's no error message. Can anyone help me? (I tried to refresh this dataset in PB Desktop and it worked)684Views0likes1CommentProblem to import data from SQL Server View
Hi, I've all my data in Azure SQL Server and I created some views to use in Power BI Desktop. However, when I create a view with some calculations (e.g. groupby) in SQL Server Management, Power BI cannot import the data: Failed to save changes to server. Error returned: "OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout exceeded. ". Some disclaimers: 1) Power BI works for this view when I use Direct Query 2) For simpler views (just selecting some columns from a table), it´s possible to import data SQL CODE to create a view: CREATE VIEW marketing.Leads5 AS SELECT DISTINCT (l.Email) AS [Email Lead] , l.Cargo AS Cargo , l.ID_lead as id_lead , l.Empresa as Empresa , l.Funcionários as [Tamanho da Empresa] , l.Segmento as Segmento , l.Website as [Site da Empresa] , COUNT(c.Identificador) as Conversões FROM dbo.leads l LEFT JOIN dbo.conversions c ON l.Email = c.Email GROUP BY l.Email, l.Cargo, l.ID_lead, l.Empresa , l.Funcionários , l.Segmento, l.Website Could anyone help me with this issue?4.7KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.