question

ccceee avatar image
0 Votes"
ccceee asked DSPatrick answered

Data does not refresh on Power BI Service

Hi,

I created a report on Power BI desktop with Web data (two excel files stored on the company's One Drive/SharePoint folder, and the analysis entails merging data between the two files) and published on Power BI Service.

Any changes made in the source data in One Drive is reflected right away on Power BI desktop. However, Power BI Service has a problem of refreshing. It is indicating a cred200420-error.pngential problem.

As I try to edit the credential information on Power BI Service, the following window pops up/
200437-%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88-2022-05-09-231214.png

I chose the credential method Basic, and entered my organizational ID and password - but it gives me error message below.


データ ソース エラー少なくとも 1 つのデータ ソースの資格情報がないため、スケジュールされている更新が無効です。更新を再度開始するには、このデータセットの設定ページに移動し、すべてのデータ ソースの資格情報を入力してください。その後、スケジュールされている更新を再アクティブ化します。Data source error The scheduled update is invalid because you do not have the credentials for at least one data source. To start the update again, go to the settings page for this dataset and enter the credentials for all data sources. Then reactivate the scheduled update.

クラスター URIWABI-NORTH-EUROPE-J-PRIMARY-redirect.analysis.windows.net
アクティビティ IDbae684c2-6061-4f67-b3a8-f56fc9ed3d65
要求 ID5023b2ef-21d2-8db5-bbe3-34d5ac760bf6
時刻2022-05-10 02:01:54Z



I tried different combination of the information entered for Credential information, but it does not go anywhere.
The privacy level setting for the dataset on Power BI Desktop is set as Organizational, and I am assuming that it is correct.

Some of the postings in the Power BI community suggest that I try using Gateway but I wonder if I have to go that path... In fact, I have tried gateway option and continue facing the problem of accessing the SharePoint files (error reason: AccessUnauthorized)


If there is any other way to solve this issue, I'd like to try. Appreciate anyone's help.




power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and 145510-image.png if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.