Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Jacek76
New Member

Dataset is not updating after publish

I changed "Data Source" in desktop application and publish report to online workspace. I get "Success" message but dataset in online workspace didn't change. There is an error:
"Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

 

I know there are "missing credentials" because data source are wrong (were set to local computer of one user) and they were not changed after publishing.

Do you know why "Data Source" in online dataset don't change even thought publishing was "Success"?

10 REPLIES 10
aj1973
Community Champion
Community Champion

Hi @Jacek76 

Some times changing the data source in your Power Bi Desktop is a headache. How did you do it? Make sure through Power Query that all your tables have changed the source. Also, you might want to check the Gateway.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

I changed data sources manualy in File/Option and Settings/Data Source Settings
Then I made 'Refresh' and successfully updated all data. Then I "Publish", got message "Success" but dataset in online workspace didn't change.
But when I rename .pbx file on my computer and then publish it in the same workspace but under different name then everything works ok. Unfortunately I have to update original dataset under original name because 3 different reports are based on this dataset.

aj1973
Community Champion
Community Champion

You can just delete the dataset from the workspace and republish the report at the same workspace without changing its name, it will work. However the embed code will change and will have to generate a new one.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

And what about reports that were created using this dataset? Will they still work after deleting it and publish it again? if the embed code changes?

aj1973
Community Champion
Community Champion

No, once you delete the dataset from the workspace, all reports that are attached to the dataset will be deleted automatically as well. The embed code will change as you will have to generate a new code.

 

My suggestion is you keep on digging to find where it didn't work with your original dataset until you find the source. I am sure it is there somewhere, I have been through the same issue and manualy I got it fixed.

 

Be patient 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

So I can't delete the dataset and publish it again 😞

Strange thing is that even Microsoft support can't find the solution 😞

aj1973
Community Champion
Community Champion

Sorry but Microsoft can't find solution to what?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Can't find solution why dataset is not updating after publish from desktop application

aj1973
Community Champion
Community Champion

I wouldn't say they can't, probably they don't want to! did you open a ticket?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Yes, ticket is opened. Thay are analysing logs from Fiddler since few days

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.