marclelijveld / External-Tools-Model-Documentation

This repository includes everything that is needed in order to run the External Tools capability in Power BI Desktop and generate Model Documentation.
https://data-marc.com/model-documenter/
MIT License
111 stars 43 forks source link

DataSource.Error: OLE DB: Errors in the OLE DB provider #17

Closed VJk17 closed 2 years ago

VJk17 commented 3 years ago

I'm getting below error DataSource.Error: OLE DB: Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect

Do I need to pass the "%server%\" & "%database%\" value in .ps1 script ? can't find server and DB details. Could you please share what values we need to pass in ?

marclelijveld commented 3 years ago

Hi @VJk17

The server and database should be passed automatically to the tool. This error points most likely to a live connected model. Is your report connected to an Analysis Services dataset or a dataset published in the Power BI Service?

This is a known limitation. Please be aware that the dataset must be loaded into memory (pbix) of the PC before it can load the model documentation.

--Marc

marclelijveld commented 2 years ago

Model Documenter v2.0.0 has just been released. Please check this page to get the latest version. All pending issues should be fixed by now. Also see pull request #21