refresh problem

2 Topics

(Refreshing power bi report connecting to Sqlite db)- Error message
Hi, all experts, I have a power bi report connecting with Sqlite database which located at the network drive, When using power bi desktop, everything can run smoothly, howerver, when I want to publish it to Power BI server and do schedule refresh, it showed the below error message. Error code: SessionID: 49958275-b41a-4e65-9a1c-fbee81fca9cf [0] -1055784932: DataSource.Error: ODBC: ERROR [HY000] unable to open database file (14). DataSourceKind = Odbc. DataSourcePath = database=\\na06\pro\PowerBI Pro\OES PowerBI\FAC\AMC\AMCEQStatus.db;dsn=SQLite3 Datasource;longnames=0;notxn=0;stepapi=0;syncpragma=NORMAL;timeout=1000. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). 。Exception from IDbCommand interface。 For background information, BI server has installed ODBC driver for sqlite, however, the error message still showed. How can I solve the problem. Jeffrey
JeffreyChou
3 years ago Place Report Server
454Views
0likes
0Comments
Not possible to refresh a web source in Report Server
Our customer is using Power BI Report Server. The current report should get Parquet files from S3 storage. We tested the Parquet connector but it failed. Only small files could be read into PBI. Next step was to, in our own framework, create an API that can be called via https. We created an empty query defining a function, something like this: let get_pq = (param1, param2 => let authString = "<auth_string>" request_query = Web.Contents(<request_url>&<auth_string>) buffered_query = Binary.Buffer(request_query) Source = Parquet.Doument(buffered_query) in Source in get_pq The function does it job and data can be retrieved without any issues. Everything in PBI Desktop works fine. So far so good. When publishing this report to PBI Repot Server, there is no way to perform a refresh the report since PBI does not recognize any data source. That can be seen as well in PBI Desktop. The report thus has a fixed content and to see new content I need to refresh it in PBI Desktop and then republish it!!!! I have tried to search for alternatives but without success. I find it strange that you can create a function that retrieves data but that is not recognized as a data source. Is there anyone that can provide one or more options or ideas to test? (we had hoped to be able to use the Delta Sharing connector but it seems to only be available in the PBI Service) Regards Lars
Solved
Lazzer897
3 years ago Place Report Server
2.6KViews
0likes
5Comments